22,209
社区成员
发帖
与我相关
我的任务
分享
已以用户 ...... 的身份执行。 Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (错误 0) Error formatting query, probably invalid parameters [SQLSTATE 42000] (错误 22050). 该步骤失败。
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Adventure Works Administrator',
@recipients = 'danw@Adventure-Works.com',
@query = 'SELECT COUNT(*) FROM AdventureWorks2012.Production.WorkOrder
WHERE DueDate > ''2004-04-30''
AND DATEDIFF(dd, ''2004-04-30'', DueDate) < 2' ,
@subject = 'Work Order Count',
@attach_query_result_as_file = 1 ;
EXEC msdb.dbo.sp_send_dbmail @recipients='danw@Adventure-Works.com',
@subject = 'Work Order List',
@body = @tableHTML,
@body_format = 'HTML' ;
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Adventure Works Administrator',
@recipients = 'danw@Adventure-Works.com',
@body = 'The stored procedure finished successfully.',
@subject = 'Automated Success Message' ;
消息 22050,级别 16,状态 1,第 0 行
Error formatting query, probably invalid parameters
消息 0,级别 20,状态 0,第 0 行
当前命令发生了严重错误。应放弃任何可能产生的结果。
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'job',
@recipients = 'job@rr.com',
@query = 'SELECT * FROM AA where a=''001''' ,
@subject = 'Work Order Count',
@attach_query_result_as_file = 1
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'job',
@recipients = 'job@rr.com',
@query = 'SELECT * FROM AA where a=''001''' ,
@subject = 'Work Order Count',
@attach_query_result_as_file = 1