SQL Server Agent is not expanding and Jobs are not visible

  • Hi,

    We are not able to expand the SQL SERVER Agent. It is taking very long time. It is throwing below error.

    Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476


    Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

    For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-1222-database-engine-error


    If the Agent opens No jobs are visible. Kindly help me to fix the issue.



  • Something is blocking/holding a lock on the query the GUI is trying to run.

    Use things like sp_who2 / sp_whoisactive (http://whoisactive.com/) / sp_blitzlock (https://downloads.brentozar.com/FirstResponderKit.zip), to see what is holding a lock and go and fix that process or terminate it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply