Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

master.dbo.xp_smtp_sendmail ( sql 2000) Expand / Collapse
Author
Message
Posted Saturday, October 11, 2008 12:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:30 AM
Points: 1,068, Visits: 3,034
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
Posted Wednesday, March 31, 2010 11:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse