[ @file_attachments = ] N'
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
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.