I am trying to setup an automated export job as a DTS package. On the final page of the export job wizard I select the save as Schedule DTS package for later execution, check the save DTS package amnd finish the export. The job never runs at the scheduled
time. But when I choose the 'run immediately' the job runs fine. Also when I check the DTS package properties, I dont see the time that I had scheduled the package, instead I only see the default time of 12AM. The SQLserver agent is running. Any
idea why this is happening.
View Complete Post