Tag Archives: Jobs

Failed Job Notification To Event Log

Posted on February 12, 2013 by

Earlier, I had written a post about a failed job issue. A friend of mine, after reading this post, asked how should he verify the SQL jobs running in his environment without this notification option? By executing the following script, … Continue reading →

Posted in Automation in SQL Server, How To, Jobs, Just Learned, SQL Server, T-SQL | Tagged , , , , , | Leave a comment

Why my Differential Backup was Failing?

Posted on November 17, 2012 by

In one of the online SQL forum, a forum user reported that, one of their server is scheduled for a weekly full database backup & daily differential database backup. However, during mid of this week, the daily differential job failed … Continue reading →

Posted in Backup - Restore, Jobs, SQL Server | Tagged , , | Leave a comment

Failed Job Issue

Posted on April 24, 2012 by

This morning I received a mail from one of our customer stating that a SQL Server job failed many times on last Friday; however, he didn’t receive any notification about it. For a moment, I thought that I had missed … Continue reading →

Posted in How To, Jobs, Just Learned, SQL Server | Tagged , , , | 3 Comments

Changing Job Owner

Posted on December 7, 2011 by

While I was about to leave from office, I received a mail from one of our customer to change the Job Owner details for 20 different jobs in four different instances. Although I prefer to use the GUI, but this … Continue reading →

Posted in How To, Jobs, Just Learned, SQL Server | Tagged , , , | Leave a comment