利用sqlserver Job 及内嵌存储过程发送邮件

if day(getdate()) = 1 begin
exec master.dbo.xp_sendmail
@recipients = 'wangwx@huntkey.net',
@blind_copy_recipients ='zhangyun@hk.net',
@attachments = '192.168.12.12ftp$csvlocdetloctype1.csv;192.168.12.12ftp$csvlocdetloctype2.csv;192.168.12.12ftp$csvlocdetloctype3.csv;192.168.12.12ftp$csvlocdetlocdet1.csv;192.168.12.12ftp$csvlocdetlocdet2.csv;192.168.12.12ftp$csvlocdetlocdet3.csv;192.168.12.12ftp$csvlocdetlocdet11.csv;192.168.12.12ftp$csvlocdetlocdet12.csv;192.168.12.12ftp$csvlocdetlocdet13.csv',
@subject = '库存分类汇总表',
@message = '请参照附件'
end
else begin
exec master.dbo.xp_sendmail
@recipients = 'wangwx@huntkey.net',
@blind_copy_recipients ='zhangyun@huntkey.net',
@attachments = '192.168.12.12ftp$csvlocdetloctype1.csv;192.168.12.12ftp$csvlocdetloctype2.csv;192.168.12.12ftp$csvlocdetloctype3.csv;192.168.12.12ftp$csvlocdetlocdet1.csv;192.168.12.12ftp$csvlocdetlocdet2.csv;192.168.12.12ftp$csvlocdetlocdet3.csv',
@subject = '库存分类汇总表',
@message = '请参照附件'
end
---参考sqlserver2005邮件配置

在 SQL Server 2005 中配置数据库邮件，发送邮件
http://www.sqlstudy.com/sql_article.php?id=2008072403
配置SQL Server 2005数据库邮件
http://blog.csdn.net/iwilltrybest/archive/2008/05/26/2481666.aspx

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/93029/viewspace-1026770/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/93029/viewspace-1026770/