KBI 311255 Enhancement: Sending SQL Query Result As Email Attachment In Argent for SQL Server

Version

Argent for SQL Server 1504-T9 and later

Date

Thursday, 16 July 2015

Summary

Argent for SQL Server has been enhanced with the facility to send SQL Query Rule result as attachment in Email Alerts

Technical Background

Argent for SQL Server 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 Oracle

Resolution

Upgrade to Argent Advanced Technology 3.1A-1504-T9 or later