master.dbo.xp_smtp_sendmail ( sql 2000)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » master.dbo.xp_smtp_sendmail ( sql 2000)

master.dbo.xp_smtp_sendmail ( sql 2000)

Rate Topic

Display Mode

Topic Options

Author

Message

ananda.murugesan

Posted Saturday, October 11, 2008 12:38 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:19 PM
Points: 823, Visits: 2,405

declare @rc int
exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'jgsrvr28',
@FROM_NAME = N'JGSERVER28',
@TO = N'',
@replyto = N'',
@CC = N'',
@BCC = N'',
@priority = N'NORMAL',
@subject = N'',
@message = N'',
@messagefile = N'D:\SQLmail\DB_Bkp\DB Maintenance Plan14_200810111104.txt',
@type = N'text/plain',
@attachment = N'',
@attachments = N'',
@codepage = 0,
@server = N'IP'
select RC = @rc
go

Above mail alert working fine, so i need, whenever jobs started that time current date report file should added in messagefile automatically

Please help me, thanks in advance

Post #584346

anuvenugopal88

Posted Wednesday, March 31, 2010 11:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 31, 2010 11:31 PM
Points: 1, Visits: 0

while using @attachments parameter , am getting an error has d file does not exist .. but d query s executed suc essfully.. but mails not sent

Post #894441

« Prev Topic | Next Topic »

Permissions