Chowdary's (10/31/2014)
Hi All,when i installed the sql server for SQL Agent Server i have selected account as SYSTEM ,After installing the Instance that SQL Agent server is showing "Agent XPS disabled",So for that i used Sp_Configure show advance option,1 ,Reconfigure i enabled XPS,Now its not showing that Agent XPS .
Sql server agent is not starting with the Local System login account,If i changed it to Administrator/Local Service it is getting start ,
My Question is ,My developers are using that server for connection string in the application ,So are they can able to create job/schedule the jobs by using their user logins.is there any issue with that,
If i want to change the Log on as LocalSystem what can i do....
I don't think being able to create and run SQL Agent jobs is dependent on what the SQL Agent service logs in as. There are roles in the MSDB database you can grant to your developer's logins that will allow them to work with jobs:
http://msdn.microsoft.com/en-us/library/ms188283(v=sql.105).aspx