• Though sp_start_job defaults to the public role, a user needs to be able to see the job in order to start it. A user can normally see a job if one of the two are true:

    (1) User is a member of the sysadmin role.

    (2) User owns the job.

    However, in order to support MSX, there is the TargetServersRole in the msdb database. Users who are made members of this role can see the jobs and execute sp_start_job.

    K. Brian Kelley


    Author: Start to Finish Guide to SQL Server Performance Monitoring


    K. Brian Kelley