SQL Server Performance Forum – Threads Archive
DTS Scheduled job hangsDTS Active X package runs fine from DTS, but when set up on scheduler the job status says ‘executing job step…’ THe data is acutally transferred and the file is moved to appropriate directory. I checked the DTS package logs and a green check shows on every step with a run status of 4 except for the last step which shows a green check and no number in the run status. I actually have to cancel the job in job scheduler. Any ideas?
Leave the job to run and check the job history.
Contributing Editor, Writer & Forums Moderator