I have a proc as below
ALTER PROCEDURE [dbo].[sp_proc_test]
WITH EXECUTE AS 'ABCD\svcaccount'
EXEC msdb.dbo.sp_start_job @job_name = 'JB_ABC_Run'
I setup a proxy account for windows login and mapped a SQL login to it. When I try to execute through a SQL login, I am getting following error.
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
I have made sure the windows (ABCD\svcaccount) login has full access (owner) to the msdb db.
What am I missing?