Category Archives: Jobs

Failed Job Notification To Event Log


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?


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


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


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