Hello, SQL 2008 R2 Standard
I have a job that has three steps 1- execute a job on another server, 2- run a batch job, 3- execute a restore transaction log.
This runs most of the time when executing the job manually by selecting "Start at step", however it fails on the batch job when ran as scheduled.
Now after the failure that says "The system cannot find the file specified" I can go in and successfully run the step from a right click and "Start at step"
So to some up if ran as scheduled it fails but can be restarted at step that failed and finish. Started manually runs okay. How can I find the problem?
Thank you,
djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!
I have a job that has three steps 1- execute a job on another server, 2- run a batch job, 3- execute a restore transaction log.
This runs most of the time when executing the job manually by selecting "Start at step", however it fails on the batch job when ran as scheduled.
Now after the failure that says "The system cannot find the file specified" I can go in and successfully run the step from a right click and "Start at step"
So to some up if ran as scheduled it fails but can be restarted at step that failed and finish. Started manually runs okay. How can I find the problem?
Thank you,
djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!
