master.dbo.xp_smtp_sendmail ( sql 2000)

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  October 11, 2008 at 12:38 am

  #72138

  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

• anuvenugopal88

  SSC Journeyman

  Points: 81

  More actions

  March 31, 2010 at 11:41 pm

  #1143687

  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