Error: 17883,  The Scheduler 0 appears to be hung.

Posted on 2003-03-19
Medium Priority
Last Modified: 2012-06-21
Hello friends,

Have you seen an error message like this in the logs?

Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 7, ECID 0, UMS Context 0x254E4F58.

Do you know what happened and what to do to fix?  Thanks.
Question by:mbatuchic
  • 2
  • 2
LVL 34

Accepted Solution

arbert earned 200 total points
ID: 8169054
For some reason SQL Agent thinks the job is not responding.  I've had this happen a couple of times and have had to restart SQL Agent.

What's the job do?


Author Comment

ID: 8217968

This happened right before a scheduled integrity check job and it happened again in the middle of a scheduled backup job.

The integrity check ran fine after that and the backup also continued after the error loged and ran fine also.

Does this mean the error has something to to with the sql agent and jobs?  How can I stop this from happening?

Thank you.

Author Comment

ID: 8220425
I found a solution to my problem and will like to share with you.  The following Microsoft KB article has some vital information about the hung scheduler problem:



Thanks for all who tried t help me.

LVL 34

Expert Comment

ID: 8962773
mbatuchic , please close this question.....

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question