Tag Archives: SQL Agent

CmdExec vs Powershell – error? What error?

Posted on October 20, 2020 by thomasrushton

Just a quickie Batch file scripts, called by SQL Agent, are not propagating their errors back up to the SQL Server job system because…. they’re being called from a Powershell script? To replicate the problem, create a .bat file containing … Continue reading →

Posted in Uncategorized | Tagged , , , | Leave a comment

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

Skype for Business – SQL Server Frustrations

Posted on August 1, 2017 by thomasrushton

Scenario The environment is new and secure. Assumptions: You are a DBA who knows how to build WSFCs and AGs. If you need help with that, then you’re in the wrong place for this post. The Windows 2016 / SQL … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

SQL Jobs – On a Calendar?

Posted on April 30, 2016 by thomasrushton

SQL Server backup jobs are IO-intensive, he says, stating the obvious. When you have a lot of servers which have been set up over the years, and you’re new to the environment, and want to see when storage is being … Continue reading →

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

T-SQL Tuesday #35 – Soylent Inbox

Posted on October 9, 2012 by thomasrushton

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

Posted in T-SQL Tuesday | Tagged , , , , | 1 Comment