Tag Archives: Scheduled Tasks

Testing SQL Agent Job Step Output During The Job

Posted on August 25, 2020 by thomasrushton

(This follows on from my previous script about emailing SQL Job ouput.) There are times when a SQL server scheduled task needs to look at the output from the previous step, and make decisions based on that – particularly when … Continue reading →

Posted in Uncategorized | Tagged , , , | 1 Comment

SQL Server Agent Job output to email

Posted on August 11, 2020 by thomasrushton

I came across a need for SQL Server Agent job output to be emailed out to the developer who created the code that the job was running. For various reasons, they don’t necessarily have access to the SQL Server itself … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments

Waiting for a job to complete

Posted on July 21, 2020 by thomasrushton

You know how it is. You need to wait for a job to complete before moving onto the next one… And, just sometimes, you need to do the same with SQL Server. MSDB The msdb system database contains various tables … Continue reading →

Posted in Uncategorized | Tagged , , , | 3 Comments