search

BrentOzarULTD / SQL-Server-First-Responder-Kit

sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
http://FirstResponderKit.org
Other
3.33k stars 992 forks source link

`sp_BlitzLock` Lock data #3548

Closed Imran-imtiaz48 closed 3 months ago

Imran-imtiaz48 commented 3 months ago

Current Behavior:

Installed sp_BlitzLock into the master database and executed it. The output ends with the following lines:

Update some nonsense part 2 Jun 26 2024 1:31:57:757PM
Finished at Jun 26 2024 1:31:57:757PM
Get Agent Job and Step names Jun 26 2024 1:31:57:770PM
Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the nvarchar value 'SQLAgent - Job Manager' to data type int.

This SQL Server instance has a large number of SQL Server Agent jobs, which might be contributing to the issue.

Steps to Reproduce:

To reproduce this behavior, execute the following command:

exec sp_BlitzLock

Expected Behavior:

The procedure should complete and produce the output grid.

Affected Versions:

This procedure has not been run on this server before but has completed successfully on other servers earlier this year.

BrentOzar commented 3 months ago

Hi! When you open an issue, there's a template with questions to fill out. Please don't delete questions - please fill them out so we can diagnose the issue. Thanks!