SQLScripts

Description: This is a collection of handy SQL scripts for MS SQL Server

JobHistory

Returns a list of all (or single specified) jobs on the server and their status for the last 24 hours
Handy for looking for failed job runs or perhaps frequency of a job

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
CheckAllServerDatabasesForPresenceOfData.sql		CheckAllServerDatabasesForPresenceOfData.sql
DB_Lines_Of_Code.sql		DB_Lines_Of_Code.sql
FindForeignKeysReferencingTable.sql		FindForeignKeysReferencingTable.sql
Find_RowCount.sql		Find_RowCount.sql
Find_SQL_Jobs_WithSpecificCommand.sql		Find_SQL_Jobs_WithSpecificCommand.sql
Find_Tables_Identity.sql		Find_Tables_Identity.sql
JobHistory.sql		JobHistory.sql
README.md		README.md
TSQL-Create_Object_Stubs.sql		TSQL-Create_Object_Stubs.sql
TSQL-Query_Running_Processes.sql		TSQL-Query_Running_Processes.sql
TSQL-Read_XML_into_Temp_Table.sql		TSQL-Read_XML_into_Temp_Table.sql
TSQL-Search_String_Multi_Chars.sql		TSQL-Search_String_Multi_Chars.sql
TSQL-Stub_Scalar_Function.sql		TSQL-Stub_Scalar_Function.sql
TSQL-XML_Manipulation.sql		TSQL-XML_Manipulation.sql
TSQL-XQuery_Optimizations.md		TSQL-XQuery_Optimizations.md

Provide feedback