SQL Jobs Archives - Technology with Vivek Johari

SQL Script to find the list of all the jobs failed yesterday

January 20, 2015October 28, 2018 vivekjohariLeave a Comment

One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all the jobs which are failed yesterday. SELECT DISTINCT CAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) AS ‘Failure Date’, SUBSTRING(T2.name,1,40) AS ‘Job Name’, T1.step_id AS ‘Step_id’, T1.step_name AS ‘Step […]

Script to find all the running queries/jobs on the Database Server

January 4, 2015April 27, 2018 vivekjohari1 Comment

Below is the query to find out all the Queries and their details like SSID etc. running on the SQL Server from all databases. It helps in finding out which queries/jobs running on the server. It can be helpful in detecting the blocking queries also. USE Master SET NOCOUNT ON SET ANSI_PADDING ON SET […]