Nov 23, 20201 minQuery to find last run status of scheduled JobsIn order to get or find last run status of scheduled Jobs, run below script : USE msdb GO SELECT DISTINCT SJ.Name AS JobName,...
Nov 23, 20202 minSQL Script (T-SQL) to find SQL Server detailsIn order to get or find SQL Server details, run below script : CREATE TABLE #ServerDetails(ID int, Name sysname, Internal_Value int,...
Nov 23, 20201 minSQL Script to check top running queries and cpu consumption by TablesIn order to get or check top running queries and cpu consumption by tables, run below script : SELECT TOP 50 [Average CPU used] =...