Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to grant permissions to scheduling and running jobs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-11-05 : 13:50:53
Stacy writes "How can I give permissions to an individual or group to schedule and run SQL Server jobs without putting them a sysadmin role? They have limited permissions on the server
(e.g. select insert update delete on tables and execute on some stored procedures). Do I need to grant execute to some stored procs in MSDB? We are running NT 4.0 Server SP6 and SQL Server 7.0 SP2

Thanks!"

   

- Advertisement -