processadmin role

processadmin role

Post by U2FuamF » Sun, 09 May 2004 06:41:03

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


processadmin role

Post by Hari Prasa » Sun, 09 May 2004 13:46:17


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:

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.