Can we attach log files / any files in mail for SQL server agent jobs mail notification? can we configure it in database mail configuration?

Question

After completion of a SQL server agent job running a report will be logged in SQL server, but in notification mail only with some specific details mail will be sent to required participants so I am having a doubt on attaching log file in that mail notification to verify the complete log details of a job. Please let me know anyone as I am new to SQL server agent jobs configuration.

Answer 1

Hi @sai satish
Try sp_send_dbmail in the msdb database.

[ @file_attachments = ] N'file_attachments'

A semicolon-delimited list of file names to attach to the e-mail message. Files in the list must be specified as absolute paths. The attachments list is of type nvarchar(max).

By default, Database Mail limits file attachments to 1 MB per file.

Before use, Database Mail must be enabled using the Database Mail Configuration Wizard, or sp_configure.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.