July 14, 2008 at 4:26 am
Hi I have a scheduled job with 22 steps set up to run once weekly. It has processed before with no issues until this week. The job processed as normal upto step 7 then went through the remaining steps 8-22 in less than 5 seconds reporting no errors. If steps 8-22 ran through normally I would expect these to take a couple of hours.
In job history all that is reported is
Executed as user: . DTSRun: Loading... DTSRun: Executing... DTSRun: Package execution complete. Process Exit Code 0. The step succeeded.
If I rerun the job manually it works ok!
There are no messages in the error log, the server has disk space and the user account running SQL Agent has access rights and is a valid login.
Any ideas on why this has happened or if anyone else has experienced this it would be greatly appreciated
July 14, 2008 at 8:19 am
I would like to recommend to add the log file in your job to trace the detail error.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply