Permissions to add SQL jobs

We have a situation where we need to allow a developer to add jobs to SQLServer, but are unable to find the right combination of permissions to do so. We do not want to give them permissions to the server for some of the canned "Server Roles". This login may need access to add DTS packages as well.
Any ideas where to start?
sdunkinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
crsankarConnect With a Mentor Commented:
As far as creating jobs using sp_add_job are concerned the execute permission is available for public, which means any login can create a job.
0
 
danchrCommented:
You might start by looking at the permissions of the user in the msdb database.  Specificaly check sp_addtask.  You might also need to disect that proceedure to figure out what tables the user needs what permisions on in the target database.
0
 
sdunkinAuthor Commented:
Also had to give permission to sp_enum_sqlagent_subsystems (which is not assigned by default to public). Thanks for the start!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.