below is the script i have in SQL Server Agent.
SET ROWCOUNT 0
@profile_name = 'SQL Mail',
@recipients = '<email@example.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 = ',',
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?