Advertisement

Send Database Backup Report Daily by a Job

Share the blog:

How to Send Database Backup Report Daily by a Job

Send Database backup report daily by a Job. Here we will use a TSQL script for the activity. The script will create two temporary tables for the activity and use Database mail profile to send the report via email.

Steps

1) First Configure Database mail in SQL Server if it is not configured before. You can follow the link for instruction: https://www.ourtechideas.com/blog/configure-database-mail/

2) Create a Job for the activity & schedule as per your requirement

Advertisement

3) Modify the script & use it in the Job

  • Must modify in the script
    • Email Sender Name
    • DB Mail Profile
    • Recipients Email
    • Copy Recipients Email

TSQL Script

TSQL Script is collected from internet, 100% working

Download: Backup Report via Email Script

Result

Facebook Comments Box
Share the blog:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Advertisement