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.
| Author |
Topic |
|
sqlmyworld
Starting Member
38 Posts |
 Posted - 2011-10-16 : 21:20:46
|
| On SQL SERVER 2000, I want to provide appropriate SQL Agent/Job access to users so they can create/alter and run sql job using enterprise manager/SSMS. I don’t want to provide SA access to user.So in MSDB database, I provided TargetServersRole (database role access) and db_owner access to user still I got following error message:“Execute permission denied on object ‘sp_add_job’, database ‘msdb’, owner ‘dbo’ (Microsoft SQL Server , Error: 229)”After providing both db_owner and TargetServerRole on msdb I got above message. Also there is SP4 installed on SQL Server 2000.Is there any solution to fix this problem?Thanks in Adv. |
|
|
lappin
Posting Yak Master
182 Posts |
Posted - 2011-10-17 : 10:50:06
|
| http://www.sql-server-performance.com/2006/sqlagent-scheduled-jobs/ |
 |
|
|
sqlmyworld
Starting Member
38 Posts |
Posted - 2011-10-17 : 18:36:17
|
| Thanks for the link. but I have already provided TargetServersRole in SQL 2000. |
|
|
|
|
|
|
How to provide SQL Agent/Job Access