KBI 311259 Enhancement: Sending SQL Query Result As Email Attachment In Argent for Oracle
Version
Argent for Oracle 1504-T9 and later
Date
Tuesday, 21 July 2015
Summary
Argent for Oracle has been enhanced with the facility to send SQL Query Rule result as attachment in Email Alerts
Technical Background
Argent for Oracle has been enhanced to send the result of SQL Query Rule as an attachment with the Email Alert
The result file will be sent as CSV format
The Query Rule can be configured to send query result as attachment with the Email Alert using the following options:
Send Query Result As Email Attachment In CSV Format: Check this option to send the query result as an email attachment
When Testing Rule Send Attachment To: Check this option and specify an email address to which the query result is to be send when testing the Rule from GUI and WUI
Ignore Attachment If Size Is Greater Than: This specifies the attachment size limit
If the size of CSV file to be attached exceeds the specified limit, attachment will be ignored
See Also: Sending SQL Query Result As Email Attachment In Argent for SQL Server
Resolution
Upgrade to Argent Advanced Technology 3.1A-1504-T9 or later