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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics