• Well, by the default users does not have access to jobs at all...

    If you want to give users permission to start a certain job, look this article on my web site: http://www.sommarskog.se/grantperm.html.

    The general topic for the article is how to give users access to do things through stored procedures in a controlled manner. But two of the examples in the article is exactly how to let users start a certain job.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]