Permission to execute job from SP

Last Post 27 Jan 2006 10:11 AM by bemall. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 Jan 2006 10:11 AM
In SQL 2005, I am trying to set up users to be able to start a job using an SP. My setup is as below.

1. I have created a user stored procedure that utilizes EXECUTES AS to excute with credentials of a specific domain account say domainname\SQLjobAccount
2. I then grant this account permission to execute sp_start_job in MSDB
as in GRANT EXECTUE TO sp_start_job to [domainname\SQLjobAccount]

All the above works fine but when I execute the SP I stil get the error
EXECUTE permission denied on object 'sp_start_job', database 'msdb', schema 'dbo'.

Please advise

Acceptable Use Policy