DTS scheduled job is hung

Last Post 07 Jul 2004 01:49 PM by PaulMcKibben. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
07 Jul 2004 08:15 AM
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
Thank you
PaulMcKibben
New Member
New Member

--
07 Jul 2004 01:49 PM
Thank you. I will try it.
You are not authorized to post a reply.

Acceptable Use Policy