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

This morning, I received an email indicating that the job failed to be executed. (The job still runs properly a few days ago. I do not know why the error occurred today)

The mail shows that the third step of the job reports an error.

Step 3:

Msdb. dbo. sp_send_dbmail
@ Profile_name = 'seagull2dbmail ',
@ Recipients = 'v-white Dan <v-baidd@sinooceanland.com> ',
@ Subject = 'feedback the first 50 statements with long execution time ',
@ File_attachments = '\ 10.0.9.20.\ bcp \ bcp_10.0.8.103 \ top_ SQL .xls'

Run the preceding statement separately and report the following error:

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

Solution:

Configure 'database mail' to increase the 'maximum file size (in bytes.

Set the 'maximum file size (in bytes) to a greater value (the default value is 1000000, that is, 1 M)

After the settings are complete, execute Step 3. No error is reported. (* ^__ ^ *) Xi ......

This article translated from: http://www.dbdigger.com/, and made some changes.