June 19, 2007 at 10:04 am
Hi, Can someone tell me what the minimum permissions level is needed for an account (local or domain) to successfully run jobs? Does it need to be a sysadmin, or can it be scaled back?
Thank You,
Jim
Regards, Jim C
June 20, 2007 at 12:10 am
It does not necessarily need SYSADMIN permissions but it needs permissions that are very particular and if your jobs access resources better to run the service in a domain account. You have find an article from brain in this forum about giving permissions for executing jobs.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 20, 2007 at 9:11 am
At minimum, a user must own the job to be run and must have EXEC permission for sp_startjob in msdb.
Greg
Greg
June 21, 2007 at 8:14 am
Today is your lucky day ... I just ran into this information in another forum earlier this week ... try this:
use msdb
exec master..sp_addlogin 'testme', 'testme', 'msdb'
exec msdb..sp_adduser 'testme', 'testme', 'TargetServersRole'
grant execute on sp_add_job to TargetServersRole
grant execute on sp_add_jobstep to TargetServersRole
grant execute on sp_update_job to TargetServersRole
grant execute on sp_add_jobserver to TargetServersRole
grant execute on sp_add_jobschedule to TargetServersRole
grant execute on sp_delete_jobschedule to TargetServersRole
grant execute on sp_delete_job to TargetServersRole
grant execute on sp_start_job to TargetServersRole
grant execute on sp_stop_job to TargetServersRole
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply