Permission to execute job from SP

Last Post 27 Jan 2006 10:11 AM by bemall. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bemall
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



You are not authorized to post a reply.

Acceptable Use Policy