File attachment or query results size exceeds allowable value of 1000000 bytes.
来源:互联网 发布:手机彩票计划软件 编辑:程序博客网 时间:2024/04/30 13:25
今天早晨,收到了作业执行失败的邮件(前几天还能正常运行该作业,不知为何今天出错)
邮件显示,作业的第三个步骤报错。
step3内容:
msdb.dbo.sp_send_dbmail
@profile_name = 'Seagull2DBMail',
@recipients = 'v-白丹丹 <v-baidd@sinooceanland.com>',
@subject = '反馈前50条执行时间比较长的语句',
@file_attachments='\\10.0.9.137\bcp\bcp_10.0.8.103\top_sql.xls'
单独执行上面的语句,报错:
File attachment or query results size exceeds allowable value of 1000000 bytes.
解决办法:
配置‘数据库邮件’,将‘最大文件大小(字节)’设置得大些。
将‘最大文件大小(字节)设置得大些(默认是1000000,即1M)
设置完成后,再执行下step3,不再报错了。(*^__^*) 嘻嘻……
本篇文章译自:http://www.dbdigger.com/ ,并做了些许改动。
0 0
- File attachment or query results size exceeds allowable value of 1000000 bytes.
- File attachment or query results size exceeds allowable value of 1000000 bytes
- Spring Boot:The field file exceeds its maximum permitted size of 1048576 bytes.
- Spring Boot修改最大上传文件限制:The field file exceeds its maximum permitted size of 1048576 bytes.
- HP-UX执行脚本报错The specified value exceeds the user's allowable limit;Cannot create the specifie file
- Save MySQL query results into a text or CSV file
- Save MySQL query results into a text or CSV file
- ORA-01144: File size (4224000 blocks) exceeds maximum of 4194303
- ORA-01144: File size (4224000 blocks) exceeds maximum of 4194303
- .\ethercat.axf: error: L6047U: The size of this image (33488 bytes) exceeds the maximum allowed for
- Spring Boot 批量上传: The field files exceeds its maximum permitted size of 1048576 bytes.
- ..\OBJ\LCD.axf: error: L6047U: The size of this image (34984 bytes) exceeds,KEIL5破解方法
- Spring Boot 批量上传: The field files exceeds its maximum permitted size of 1048576 bytes.
- LINK : fatal error LNK1248: image size (C1F22000) exceeds maximum allowable size (80000000)
- Load region LR_IROM1 size(131996 bytes) exceeds limit (131072 bytes)
- The size of this image (170286 bytes) exceeds the maximum allowed for this version of the linker
- error: L6047U: The size of this image (32868 bytes) exceeds the maximum allowed for this version of
- ORA-01144: File size (string blocks) exceeds maximum of string blocks
- crm2011创建自定义实体Entity
- SpringMVC经典系列-12基于SpringMVC的文件上传---【LinusZhu】
- Python爬虫之路——简单网页抓图升级版(增加多线程支持)
- Swift学习——Language Guide 基础
- 内核多线程测试内存工具
- File attachment or query results size exceeds allowable value of 1000000 bytes.
- Android应用程序请求SurfaceFlinger服务创建Surface的过程分析
- 百度搜索实习生面经~~~~~
- Phpmywind教程:关于广告位调用
- 接口,抽象类
- 选择广告平台的几个重要指标
- Spring事务管理的前世今生(转载于IT江湖)
- Window快捷键(目标脱离鼠标)
- java-反射深度剖析