Friday, February 24, 2012

Can any please tell me how to make a user to see sql jobs.

Can any please tell me how to make a user to see sql jobs.
I know sys admins can see the jobs, but i want to give access to a user who
is not sys admin.
Thanks
Raju
Hi
If they are the owner of the job they will be able to see the job details,
but will mean that they can execute them as well. You may want to write your
own procedure to view the information.
John
"Raju" <npraju1@.hotmail.com> wrote in message
news:Oxr0p0AsFHA.2596@.TK2MSFTNGP09.phx.gbl...
> Can any please tell me how to make a user to see sql jobs.
> I know sys admins can see the jobs, but i want to give access to a user
> who
> is not sys admin.
> Thanks
> Raju
>

No comments:

Post a Comment