call SSIS JOB From Stored Procedure
hi Guys,
we deploy ssis package and create job in test server.
i am calling job from Stored Procedure with "sp_start_job" . I AM getting message like u don't execute permission while trying to execute SP . is there any way......
September 24th, 2011 11:29am
vamsi1980,
In order to have permission to run sp_start_job, you need to be executing it as a SQL Server user that is a member of the sysadmin role. Or, you should be able to execute it by giving your user account these roles: SQLAgentUserRole, SQLAgentOperatorRole,
or SQLAgentReaderRole. Tom Overton
Free Windows Admin Tool Kit Click here and download it now
September 24th, 2011 11:48am
hi Guys,
we deploy ssis package and create job in test server.
i am calling job from Stored Procedure with "sp_start_job" . I AM getting message like u don't execute permission while trying to execute SP . is there any way......
If you get an error it can be really useful to those of us trying to answer if you provide the error message.http://sqlblog.com/blogs/jamie_thomson/ |
@jamiet |
About me
September 24th, 2011 1:14pm
Not sure if this helps:http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/ca6db5b1-499d-4ecf-97f1-0daefa5c2c08
Thanks http://dwhanalytics.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
September 24th, 2011 5:47pm
i want retun value 0 for sucess ,1 for failure when i am execute job.
how can i get return value with start_job
September 25th, 2011 5:36am