SQL Server Agent Role

  • Good day,

    I have developers that I would like to give permissions to update sql agent jobs that he doesn't own. In BOL, it says the SQL Agent Operator role only allows the user to update jobs they own. It then goes on to say that only sysadmins can update jobs owned by other users. Is there a backdoor way to give users this permission? To me it seems like going from sqlagentoperatorrole to sysadmin role is quite drastic. Seems like there should be another sqlagent role to allow this.

    Here is why I want to do this:

    We have several data warehouse refresh agent jobs in our dev environment. We are trying to set them up as they will be in the production environment. The developer is working with the jobs. The jobs are owned by sa as they are in our production environment. It is very frustrating that we would have to change the owner just for this developer to update them.

    I understand why they have implemented this for in a production environment. I don't want just anyone changing my jobs but it seems like they would be a way to have an exception to the rule.

    Anyone have any suggestions on how I might accomplish this or is it just not possible?

    Or have you done something creative to get around this limitation? I don't want to give the developer sysadmin privileges to just modify these jobs.

    Thanks,

    Aileen

  • Sorry. Looks like the only way you can modify jobs is to be sysadmin or own the job.

  • Thanks! i thought there's another way, just hope they include this feature in the next sql edition they develop 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply