开发者

how to send an email on a condition when executing a job?

I'm running sql server 2005. I want to create a step in a job which executes a stored procedure, gets a result from it, and after performing a check on it, send an email. I've s开发者_StackOverflowet up Database Mail under Management and tested it and it works fine. I just don't know what the command is to send an email. Can somebody help me with this?

Thanks

Riz


You need EXECUTE msdb.dbo.sp_send_dbmail

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜