SQL Server Agent Archives -

3 Oct, 2022

T-SQL query to check failed SQL Agent Jobs in the Last 24 Hour 0 (0)

Below query can be used to check SQL Agent failed jobs in last 24 hours. This query can be used in the monitoring script to find out failed job in SQL server agent.

SELECT sj.[name] AS "Failed Job Name", jh.run_date,jh.[message]

… Read the rest

26 Sep, 2022

T-SQL script to get list of SQL Server Agent job 0 (0)

MSSQL, T-SQL Scripts SQL server, SQL Server Agent, SQL Server Agent Job

Below query can be used to get list of all the SQL Agent Job details in SQL Server.

use msdb;
go
SELECT Convert(varchar(22),SERVERPROPERTY('ServerName')) AS 'ServerName',
convert(varchar(35),j.name) as 'JobName',
j.enabled,
CASE j.enabled WHEN 1 THEN 'Enabled' Else 'Disabled' END AS 'JobStatus',

… Read the rest

Tag Archives: SQL Server Agent

T-SQL query to check failed SQL Agent Jobs in the Last 24 Hour 0 (0)

T-SQL script to get list of SQL Server Agent job 0 (0)