dbmail email from cmd

Asked Dec 26 '12 at 17:18

Active Dec 26 '12 at 17:29

Viewed 1,192 times

Is it possible to send email attachment using dbmail from cmd? I'm using a batch file to send email attachment using dbmail but getting an error. Here is my code:

sqlcmd -q "EXEC msdb.dbo.sp_send_dbmail @profile_name = 'ProfileName',
  @recipients='example@test.com',
  @subject='Test Attachment ',
  @body='Using dbmail to send attachment',
  @file_attachments='C:\document\example.txt'"

edited Dec 26 '12 at 17:29

Nathan Hughes

94,330
19
181
276

asked Dec 26 '12 at 17:18

Liton Uddin

incorrect syntax near 'exec msdb.dbo.sp_send dbmail @profile_name='auditProfile' – Liton Uddin Dec 26 '12 at 17:52
@LitonUddin have you figured this out yet? – JustinStolle May 25 '13 at 07:02

dbmail email from cmd

0 Answers0