Skip to content Skip to sidebar Skip to footer
Showing posts with the label Sql Server Agent
Run Query For Each Element In Array Or List

Run Query For Each Element In Array Or List

Post a Comment
I'm trying to monitor all connections that hit our databases. In order to do so I created this … Read more Run Query For Each Element In Array Or List
Sql Agent: Set A Max Execution Time

Sql Agent: Set A Max Execution Time

Post a Comment
Afternoon. I have several SQL Agent jobs running on an MS 2K8 BI server, some of them on a daily b… Read more Sql Agent: Set A Max Execution Time
Sql Server - Tsql To Detect Missed Agent Jobs Due To Overrun

Sql Server - Tsql To Detect Missed Agent Jobs Due To Overrun

Post a Comment
I am trying to work out the TSQL to detect if a JOB has overran and missed its next schedule. Scena… Read more Sql Server - Tsql To Detect Missed Agent Jobs Due To Overrun
Ssis Package Runs From Catalog, Not From Sql Server Agent (same User)

Ssis Package Runs From Catalog, Not From Sql Server Agent (same User)

Post a Comment
I have a SSIS package, developed for SQL Server 2012, that uses a script component to open an Excel… Read more Ssis Package Runs From Catalog, Not From Sql Server Agent (same User)