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'.