Post reply

Rights to run SQL jobs

  • December 15, 2005 at 2:52 am

    #166454

    Hi guys,

    Do you need to have sa rights to run jobs? i suspect not, if not what access rights do you need in sql server to be able to run jobs? prompt response much appreciated. Thanks

    M

  • December 15, 2005 at 5:15 am

    #609693

    You need to be a memeber of the TargetServersRole role in the msdb database. I have a feeling that this role grants more than just execute permissions though. Best to check it out.

    Karl
    source control for SQL Server

  • December 15, 2005 at 6:59 am

    #609708

    well...u dont need to have sa rights to run a job.

    But u got to use the server service account configured to make sure the jobs are running... It would be your windows SQL service account on which backup and other jobs run.

    - A

    Get busy living ....or get busy dying....

  • December 15, 2005 at 8:59 am

    #609766

    thanks your response greatly appreciated

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

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