Monday, March 12, 2012

Permissions for running sp_Start_Job and xp_sqlagent_enum_jobs

Anybody know what permissions I need to give a user so
that they can execute msdb.dbo.sp_start_job and
xp_sqlagent_enum_jobs? I don't want to give them Admin
access..The user needs to own the job if you don't want them to be a
sysadmin.
-Sue
On Wed, 3 Sep 2003 08:21:05 -0700, "Rich"
<rslack@.asda.co.uk> wrote:
>Anybody know what permissions I need to give a user so
>that they can execute msdb.dbo.sp_start_job and
>xp_sqlagent_enum_jobs? I don't want to give them Admin
>access..

No comments:

Post a Comment