locked
How I have to set the permissions for a user that he can change a job schedule RRS feed

  • Question

  • Hi.

    The enduser should have rights to change the starttime of a preassigned schedule for a job. Which permissions he must own to do so? I do not find anything about that in the forum.

    I implemented it using the system stored proedures I got from the SSMS.

    THX Nils

    Wednesday, April 28, 2010 3:15 PM

Answers

  • There are three predefined roles in msdb database that control rights for manipulating the jobs.  These are:

    SQLAgentUserRole - Start/stop and see history of own local jobs
    SQLAgentReaderRole - Start/stop own local jobs and see history of all local jobs
    SQLAgentOperatorRole - Start/stop all local jobs and see history of all jobs

    All of these say that they can modify 'owned schedules' only.
    http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

    If necessary, you should be able to create a stored procedure that executes under a certificate with the proper rights.  You can read about this at:
    http://msdn.microsoft.com/en-us/library/bb283630.aspx

    RLF

    Wednesday, April 28, 2010 6:30 PM