File attachment or query results size exceeds allowable value of 1000000 bytes.

This morning, I received a message that the job failed to execute (I can still run the job a few days ago, I don't know why I made a mistake today)

The message shows that the third step of the job is an error.

Step3 content:

Msdb.dbo.sp_send_dbmail
@profile_name = ' Seagull2dbmail ',
@recipients = ' v Baidandan <v-baidd@sinooceanland.com> ',
@subject = ' Feedback The first 50 execution time statements ',
@file_attachments = ' \\10.0.9.137\bcp\bcp_10.0.8.103\top_sql.xls '

Execute the above statement separately, the error:

File attachment or query results size exceeds allowable value of 1000000 bytes.

Solution:

Configure ' Database Mail ' to set the ' Maximum file size (bytes) ' Larger.

Set the ' Maximum file size (bytes) larger (default is 1000000, that is, 1M)

After the setup is complete, execute the next step3, no longer the error. (*^__^*) Xi hee ...

This article is translated from: http://www.dbdigger.com/, and made a few changes.