Free for PREMIUM members
[Webinar] Streamline your web hosting managementRegister Today
@recipients = 'firstname.lastname@example.org',
@subject = 'my email subject',
@message = 'My email message...',
@query = 'select * from table',
@attach_results = false
Open in new window
@subject = 'DB Backups',
@body ='Please review latest SQL DB Backup files',
@query ='SELECT DISTINCT TOP 20
from msdb..backupset s1 inner join msdb..backupmediafamily s2
on s1.media_set_id = s2.media_set_id
where s1.database_name ="Database name 1"
and s1.backup_start_date >= "10/10/2008 06:41:25 AM"
-- You will need to change to the database you are querying
and s1.type in("D","L","I") -- sl.type in ("D","L") means full or Transaction Log backups (if "I", Differential backups) or ("F" for File Group, "G" for File Group Differential)
and s1.backup_start_date >= (select max(backup_start_date) from msdb..backupset where database_name ="Database name 1" and type ="D")
order by s1.backup_start_date desc'
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Premium members get this course for $159.20.
Premium members get this course for $37.50.
Premium members get this course for $62.50.
Premium members get this course for $12.50.
Premium members get this course for $95.20.
Premium members get this course for $99.99.
Premium members get this course for $87.50.