send mail not working when used with attachment

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » send mail not working when used with...

send mail not working when used with attachment

Rate Topic

Display Mode

Topic Options

Author

Message

sierra4

Posted Saturday, September 15, 2012 4:30 PM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 34, Visits: 418

hi,

below is the script i have in SQL Server Agent.

SET ROWCOUNT 0
EXEC msdb..sp_send_dbmail
@profile_name = 'SQL Mail',
@recipients = '<me@email.com>',
@subject = 'subject',
@body = 'Please see attached report',
@file_attachments = 'D:\MSSQL10.MSSQLSERVER\MSSQL\Log\output_report_3.txt'
--@query = 'sp_helpdb userdb',
--@execute_query_database = 'MSDB',
--@query_result_separator = ',',
go

the job completes successfully but does not send an email. there are no errors generated.

when i comment out @file_attachments, and instead uncomment the @query parameters then i do receive an email

what am i missing with the @file_attachments parameter?

thank you

Post #1359854

mbhandari

Posted Monday, September 17, 2012 9:53 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 1:44 PM
Points: 12, Visits: 137

The query looks good. I don't think there is any additional arguments to be passed for attachements. The only thing I would like to point out is SQL Server limits the size of attachment to 1 MB by default.

Post #1360299

sierra4

Posted Tuesday, February 19, 2013 11:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:58 AM
Points: 34, Visits: 418

The script above does indeed work -- the email just went to the junk folder BigGrin

Post #1421791

« Prev Topic | Next Topic »

Permissions