Scheduled Tasks

[Ed Molinari]

To all,
If I have a scheduled tasks that is owned by 'sa', how can I assign permissions to allow another user, even the database dbo, to register the SQL server and view the scheduled tasks?

Thanks in Advance,
Ed Molinari

[Craig]

If this is 6.5, you would need to provide access to msdb and allow the stored procedures required for the depth of access you wish to provide.

Tecnet has information on this. I just played with it until they got the access they needed.


------------
Ed Molinari at 6/23/99 8:39:24 AM

To all,
If I have a scheduled tasks that is owned by 'sa', how can I assign permissions to allow another user, even the database dbo, to register the SQL server and view the scheduled tasks?

Thanks in Advance,
Ed Molinari