luckysql.kinda (9/23/2009)
Yes this user should be able to run only sql jobs (any jobs; not only his own) and nothing else.-lk
Could be interesting, you need to give him SQLAgentoperatorRole to allow him to execute any sql jobs on that server, are you also aware that if you give him that role, he will able to also do the following.
Create/modify/delete his own jobs
enable/disable any jobs
view properties on any job
edit any jobs that he owns/creates
start and stop any job
view job history for all jobs
delete job history for all jobs
It is the most priviledged out of all the job roles and implies a lot of trust, you can in theory do it by granting access to certain stored procedures to allow starting the jobs, but that is not that easy and can be a pain to troubleshoot to get exactly right.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]