I have a job scheduled in SqlServer Agent that runs nightly. It executes a DTS package.
Up until last night it had been running without any problems. Now the job is displaying as still executing even though it should have finished hours ago. The DTS package it calls has successfully executed, I can tell this from sysdtspackages, but the job does not show as complete.
The Jobhistory log is not full, so that is not a problem, and when I eventually stoped the job the jobhistory table told me nothing other that the job had been cancelled. Has anybody had a problem like this before?
Any help would be appreciated.
Many thanks in advance