DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2795690 - Last Review: January 11, 2013 - Revision: 1.0

Symptoms

A . Additionally, you may experience one or more of the following scenarios:
  • Scenario 1

    The following error message is logged in the System event log:
    The service did not respond to the start or control request in a timely fashion
  • Scenario 2

    The status of the agent is displayed as "Starting" in Control Panel, and the following error message is logged in the SQLAgent.log file:
    An idle CPU condition has not been defined - OnIdle job schedules will have no effect

    Additionally, the following entries may be logged in the SQLAgent.log file:
    <Time Stamp> - ? [431] Populating subsystems cache...
    <Time Stamp> - ? [432] There are 7 subsystems in the subsystems cache
    <Time Stamp> - ? [124] Subsystem 'ActiveScripting' successfully loaded (maximum concurrency: 40)
    <Time Stamp> - ? [124] Subsystem 'ANALYSISCOMMAND' successfully loaded (maximum concurrency: 400)
    <Time Stamp> - ? [124] Subsystem 'ANALYSISQUERY' successfully loaded (maximum concurrency: 400)
    <Time Stamp> - ? [124] Subsystem 'CmdExec' successfully loaded (maximum concurrency: 40)
    <Time Stamp> - ? [124] Subsystem 'PowerShell' successfully loaded (maximum concurrency: 2)
    <Time Stamp> - ? [124] Subsystem 'SSIS' successfully loaded (maximum concurrency: 400)
    <Time Stamp> - ? [124] Subsystem 'TSQL' successfully loaded (maximum concurrency: 80)
    <Time Stamp> - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
    <Time Stamp> - ? [129] SQLSERVERAGENT starting under Windows NT service control 
    <Time Stamp> - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
    <Time Stamp> - ? [110] Starting SQLServerAgent Monitor using '' as the notification recipient...
    <Time Stamp> - ? [146] Request servicer engine started
    <Time Stamp> - ? [133] Support engine started
    <Time Stamp> - ? [167] Populating job cache...
    <Time Stamp> - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
    <Time Stamp> - ? [134] Support engine stopped
    <Time Stamp> - ? [197] Alert engine stopped
    <Time Stamp> - ? [168] There are 4731 job(s) [0 disabled] in the job cache
    <Time Stamp> - ? [170] Populating alert cache...
    <Time Stamp> - ? [171] There are 0 alert(s) in the alert cache
    <Time Stamp> - ? [149] Request servicer engine stopped
    <Time Stamp> - ? [248] Saving NextRunDate/Times for all updated job schedules...
    <Time Stamp> - ? [249] 0 job schedule(s) saved
    <Time Stamp> - ? [127] Waiting for subsystems to finish...
    <Time Stamp> - ? [128] Subsystem 'ActiveScripting' stopped (exit code 1)
    <Time Stamp> - ? [128] Subsystem 'ANALYSISCOMMAND' stopped (exit code 1)
    <Time Stamp> - ? [128] Subsystem 'ANALYSISQUERY' stopped (exit code 1)
    <Time Stamp> - ? [128] Subsystem 'CmdExec' stopped (exit code 1)
    <Time Stamp> - ? [128] Subsystem 'PowerShell' stopped (exit code 1)
    <Time Stamp> - ? [128] Subsystem 'SSIS' stopped (exit code 1)
    <Time Stamp> - ? [175] Job scheduler engine stopped
  • Scenario 3

    A SQL Server process ID (SPID) from the "SQLAgent - Generic Refresher" service is displayed on the database engine server. Additionally, the following job is displayed as running in the input buffer of the SPID:
    EXECUTE msdb.dbo.sp_sqlagent_refresh_job

    Note The SPID is in the RUNNABLE state and regularly waits for the PREEMPTIVE_OS_LOOKUPACCOUNTSID wait type. Or, the SPID is in a waiting state for the ASYNC_NETWORKIO wait type.

Cause

This issue occurs because there are many job entries in SQL Server.

Note This can occur if you unintentionally set up many subscriptions for your reports in Reporting Services Configuration Manager.

Workaround

To work around this issue, delete the jobs that you do not have to have.

Note If there are many job entries because you unintentionally set up many subscriptions, delete unnecessary subscriptions by using Reporting Services Configuration Manager.

More information

For more information about how to delete the jobs, go to the following Microsoft TechNet website:

General information about how to delete jobs (http://technet.microsoft.com/en-US/library/ms187850(v=sql.110).aspx)

For more information about how to delete the subscriptions, go to the following Microsoft TechNet website:

General information about how to create, modify, and delete standard subscriptions (http://technet.microsoft.com/en-us/library/ms156307.aspx)

For more information about products or tools that automatically check for this issue in SQL Server, see the following table:
Collapse this tableExpand this table
Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated
System Center AdvisorSQL Server agent startup issues with many agent jobsSystem Center Advisor checks for the number of jobs on the instance of SQL Server that is enabled. Advisor generates this alert based on this condition. Review and delete the jobs which are enabled and you do not have to have. SQL Server 2008
SQL Server 2008 R2
SQL Server 2012

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Applies to
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Enterprise Edition
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced KB2795690
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support