August 14, 2013 at 7:10 pm
When running the job from stored proc I am getting the below error ..Can some one help me on that.
Request to run job (from User 'abc') refused because the job already has a pending request from User 'abc'.
IF NOT EXISTS(select * from msdb..sysjobhistory where job_id='9DDEWE' and run_status=4 )
BEGIN
exec sp_start_job @job_name = 'TEST'
END
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
August 15, 2013 at 4:58 am
Does the job has multiple steps?
If Yes, you should have triggered the job using Activity monitor and its waiting for response to submit your response for start at step. In the mean time you would have fired the query to run the job.
August 15, 2013 at 5:02 am
Make sure the job_id in the select correspondents with the job_name in the start command. That's a mistake I have made in the past
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy