Permission for Jobs

I have a user who needs to create jobs and also manage some already existing
jobs owned by dbo. I have added her Windows domain id in MSDB data which wil
l
allow her to create and manage her own jobs. I was trying to add her to the
TargetServersRole but this role has been denied access to stored procedures
e.g. sp_update_job in MSDB database. How can I achieve this. Please advise.
Thanks..FrazOnly members of the sysadmin server role can alter, delete and start jobs
owned by another user. This is hardcoded into the respective system stored
procedures (sp_update_job, sp_start_job etc), so if you want you can change
these stored procedures in msdb to take out the check to see if the user is
a member of the sysadmin role or owns the job. This is unsupported though.
Jacco Schalkwijk
SQL Server MVP
"Fraz" <Fraz@.discussions.microsoft.com> wrote in message
news:43343195-6BEC-4AC6-9178-B94B92CE57D5@.microsoft.com...
>I have a user who needs to create jobs and also manage some already
>existing
> jobs owned by dbo. I have added her Windows domain id in MSDB data which
> will
> allow her to create and manage her own jobs. I was trying to add her to
> the
> TargetServersRole but this role has been denied access to stored
> procedures
> e.g. sp_update_job in MSDB database. How can I achieve this. Please
> advise.
> Thanks..Fraz