Tag Archives: MSDB

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

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

Which databases were backed up in which backup task?

Posted on July 18, 2016 by thomasrushton

It’s a confusing question / title / headline. Let’s see if I can clarify what I’m after. For each scheduled backup job, which databases were backed up? And (more to the point) which databases weren’t backed up? And how can … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

How long before that backup completes?

Posted on November 23, 2011 by thomasrushton

An early start this morning, as I need to back up a big reporting database before the guys at work start running some heavy optimisation process to rationalise and compress the data.  However, I don’t necessarily know how long the … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , | 2 Comments

T-SQL Tuesday #16 – Aggregates and Average Weekly Backup Sizes

Posted on March 8, 2011 by thomasrushton

T-SQL Tuesday this month is hosted by Jes Borland. T-SQL Tuesday, which occurs on the second Tuesday of each month, provides an opportunity for many SQL Server bloggers to come together to discuss a single issue, selected by the host … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , , | 2 Comments