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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-01-19 : 09:48:25
|
| Hi,I have created a stored procedure to call a job as follows:alter procedure [dbo].[uspPackageRun]@PackageName varchar(100)asEXEC msdb..sp_start_job @job_name = @PackageNameThis is the error I get:EXECUTE permission denied on object 'sp_start_job', database 'msdb', schema 'dbo'.This is what I have tried already but no success. Do you see why please? ThanksIn the database, right click on the user for whom I am accessing the stored procedure. grant DDL_Admin rights to the user. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-19 : 11:22:36
|
| that's not going to work. refer to this article: http://msdn.microsoft.com/en-us/library/ms188283.aspx |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-01-21 : 03:38:50
|
| Thank you |
|
|
|
|
|
|
execute permission denied