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 |
|
raky
Aged Yak Warrior
767 Posts |
 Posted - 2010-03-30 : 08:28:22
|
| Hi,Iam getting the below error when iam executing a sp which internally calls sp_help_jobactivity stored procedure.The EXECUTE permission was denied on the object 'sp_help_jobactivity', database 'msdb', schema 'dbo'What i need to do to avoid this error?Pls help.. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-30 : 10:36:31
|
| "By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted one of the following SQL Server Agent fixed database roles in the msdb database:SQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole"http://msdn.microsoft.com/en-us/library/ms188766.aspx |
 |
|
|
|
|
|
Sp_Help_JobActivity