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
RajuHi,
Setup a SQL Agent proxy account.
From books online:-
When sp_help_job is invoked by a user who is a member of the sysadmin fixed
server role, sp_help_job will be executed under the security context in
which the SQL Server service is running. When the user is not a member of
the sysadmin group, sp_help_job will impersonate the SQL Server Agent proxy
account, which is specified using xp_sqlagent_proxy_account. If the proxy
account is not available, sp_help_job will fail. This is true only for
Microsoft Windows NT 4.0 and Windows 2000. On Windows 9.x, there is no
impersonation and sp_help_job is always executed under the security context
of the Windows 9.x user who started SQL Server.
Thanks
Hari
SQL Server MVP
"Raju" <npraju1@.hotmail.com> wrote in message
news:OSEJk0AsFHA.3720@.TK2MSFTNGP14.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
>|||Hari,
Thank you for the response.
I tried the method, but the user can't see the list of jobs on the EM.
I want the user to stop/start the jobs, but i don't want to make him sys
admin.
Can you please help?
Thanks
Raju
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ee7%23B1PsFHA.3080@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Setup a SQL Agent proxy account.
> From books online:-
> When sp_help_job is invoked by a user who is a member of the sysadmin
fixed
> server role, sp_help_job will be executed under the security context in
> which the SQL Server service is running. When the user is not a member of
> the sysadmin group, sp_help_job will impersonate the SQL Server Agent
proxy
> account, which is specified using xp_sqlagent_proxy_account. If the proxy
> account is not available, sp_help_job will fail. This is true only for
> Microsoft Windows NT 4.0 and Windows 2000. On Windows 9.x, there is no
> impersonation and sp_help_job is always executed under the security
context
> of the Windows 9.x user who started SQL Server.
> Thanks
> Hari
> SQL Server MVP
> "Raju" <npraju1@.hotmail.com> wrote in message
> news:OSEJk0AsFHA.3720@.TK2MSFTNGP14.phx.gbl...
>|||It won't work. When sp_help_job is executed, if a user is
not a member of the sysadmins role, they can only view jobs
they own. The proxy account doesn't come into play here.
Ownership is checked in sp_help_job that which calls
sp_get_composite_job_info. If the executing user doesn't
pass the ownership, sysadmin check, the job won't be
displayed. And if run from query analyzer, you won't get any
results back. There is no supported way to do what you want
with SQL Server 2000. One option is to add the users to the
TargetServerRole in msdb but this is not supported and the
permissions of users added to this role will vary depending
on what service pack is installed.
-Sue
On Wed, 7 Sep 2005 12:27:39 -0700, "Raju"
<npraju1@.hotmail.com> wrote:

>Hari,
>Thank you for the response.
>I tried the method, but the user can't see the list of jobs on the EM.
>I want the user to stop/start the jobs, but i don't want to make him sys
>admin.
>Can you please help?
>Thanks
>Raju
>
>"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>news:ee7%23B1PsFHA.3080@.TK2MSFTNGP15.phx.gbl...
>fixed
>proxy
>context
>