June 9, 2008 at 3:24 pm
I have a problem, I have a job in SQL Server 2005 with two steps, the first step is a SSIS package from INtegration Services, the second step is an insert of trace.
The second step in successfully calls the first setp whit a delay of 3 seconds.
The job work fine, but then of 3 hours the job is cancel.
The message is "The step was cancelled (stopped) as the result of a stop job request."
What may be happening. Thanks.
June 10, 2008 at 3:53 am
Have you checked log files for any errors?
June 10, 2008 at 8:02 am
No errors
June 11, 2008 at 12:35 am
Please check timeout option for SSIS package. Also check the query timeout option in SQL server.
June 11, 2008 at 3:54 pm
Check the Error Log under SQL Server Agent if not there check the server Error log. Does it return any code beside that message?
July 30, 2010 at 6:50 am
I had this error as well with one of my jobs. When looking at the history of the job, I would see "The step was cancelled (stopped) as the result of a stop job request." I followed Scott's recommendation to check the SQLAgent history and found out that the server was rebooting in the middle of my job and therefore stopping SQLAgent. Thanks for pointing me in the right direction Scott.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply