Post reply

Minimum rights for running a job.

  • March 1, 2010 at 10:46 pm

    #156730

    Dear All,

    One of my user (userA) should be able to execute a job manually. What are the rights I need to give .? Please guid.

    Job selects data from a view and insert into another table.

    Thanks in advance.

  • March 2, 2010 at 1:29 am

    #1126887

    ...No responses at all....!!!

    Please help...I just want to let one of my user to see and execute a prticular job manually...

    Please guide...

    Thanks.

  • March 2, 2010 at 2:10 am

    #1126896

    Please check database roles SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole on msdb database.

  • March 2, 2010 at 3:14 am

    #1126919

    role SQLAgentUserRole will able to perform this considering he owns the job. Refer the following link for further detail.

    http://msdn.microsoft.com/en-us/library/ms188283(SQL.90).aspx

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 2, 2010 at 3:17 am

    #1126920

    Yes..I got it from google. It's something new to me.

    Wanted to know if anyone else has implemented it.

    But unfortunately no response at all.

  • March 2, 2010 at 9:17 am

    #1127176

    SQLAgentUserRole works if you want a non-admin to run a job. The drawback, in my mind, is that the user can also modify or delete the job.

    An alternative is to create a stored procedure that executes msdb.dbo.sp_start_job using WITH EXECUTE AS to change context to a more privileged account. This way, the user doesn't have direct permission to execute sp_start_job. The drawback to this method is the user can't see the details of the job like he/she can as a member of sQLAgentUserRole.

    Greg

Viewing 6 posts - 1 through 5 (of 5 total)

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