Developer Forum

I need a mamber of my team to monitor some jobs set up by a DBA using SQL Job
I dont want to give him sysadmin prviledge

He should be able to see the job history and re-run the job if it fail
Should i give him processadmin rol

what does processadmin role exactly d

Thanks

Hi,

Process admin Role
---------------------

Members of Processadmin role can only kill a process. Although the
description for this role says that members can manage
the processes running in SQL Server, the only management option they have is
to kill a process.

By giving the process admin job the users cant execute or see the status of
SQL Jobs.

To view the history of job, DBA can assign the execute prev on
"sp_help_jobhistory" in MSDB database to the user.

To view the job status a normal user can execute the procedure "sp_help_job"


(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.)

Execute a Job:

sp_start_job
Execute permissions default to the public role in the msdb database. A user
who can execute this procedure and is a member of the sysadmin fixed role
can start any job. A user who is not a member of the sysadmin role can use
sp_start_job to start only the jobs he/she owns.

Thanks
Hari
MCDBA




Jobs