View but not execute jobs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy - 29 Jun 2005 20:36 GMT

Is there a security setting that ables users to view jobs and their status,
history, etc. but unable to execute them?

Reply to this Message

Jens Süßmeyer - 29 Jun 2005 21:22 GMT

Here you can also find the only viewing of the job status:

http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/threa
d/795ec20703b7b535/440f861a2c394474?q=sp_help_job+Jens&rnum=1#440f861a2c394474

In Common you should llok for sp_help_job which will extract the information
from the system tables, sysjobs,sysjobsteps,sysjobhistory (names should be
something like that)

Signature

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

> Is there a security setting that ables users to view jobs and their
> status,
> history, etc. but unable to execute them?

Reply to this Message