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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

800 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