I have three DTS jobs that are hung. They have a status of "Performing completion actions" in EM. They have been executing without issue as scheduled jobs for months. Environment : SQL2000 SP3a, Clustered SQL servers.
I have executed the sp_stop_job procedure for all three jobs. Query Analyzer reports that they stopped successfully. The status in EM didn't change. I have attempted to start the job in EM, and I get a 22022 error stating that the job cannot be started because it is already running.
Any assistance would be helpful