I use the DTS to export data to an Oracle table. However, I want to do this automatically. I want to use the scheduler in the SQL Server DTS, but after setting up the job in 'Local Packages', the time comes and goes and nothing happens. Is there some log file I can see why the package didn't run?
ThanksIf you view the job history it will show when the job tried to run. There is a tick box on this screen that will let you see what happened with individual steps.
This should show you something along the lines of the error (depending on exactly what the error was).
No comments:
Post a Comment