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 […]
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?
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 […]