Notification for missing database backups

I got a question today about sending notifications from SQL Server when there are databases which have not been backed up in the past 24 hours.

The solution is simple – schedule an SQL Server Agent job which uses Database Mail to send emails if there are missing backups. All you have to do in the

Continue reading […] Notification for missing database backups […]

 

How to find SQL Server agent jobs related to a database

When migrating a database to a new SQL Server instance, there are numerous steps to be taken, as I mention here.

One of the considerations is to move all Agent Jobs related to the database to the new instance.

How do we find which jobs to move, though?

 

How to query currently running SQL Server Agent jobs

Today I went on a quest to discover a way to list all currently running SQL Server Agent jobs. As every other quest, this one also started with Google-ing.

Within 2 minutes I found this great post by Brent Ozar on SQLServerPedia. Why is this post so great? It is so great because Brent figured

Continue reading […] How to query currently running SQL Server Agent jobs […]