WORKAROUND:
Yes an email can be pushed out through an automated job.
Yes the email can include an attachment.
Yes the email activity can be based off a condition.
For further information and guidance with automation, please check Toad Data Point's help file and Tools | Automation Tutorial regarding automation.
How to add an email activity with an attachment to an automation job:
In Toad, open Automation under Tools | Automation
1. On the left are activities. System Activities | Send Email, double click this to add the activity to the diagram, or the "Toad Automation Script" window. You can click and drag to move this activity around if needed, if working with other activities within the same automation job.
2. Highlight the email activity in the diagram, in the Activity Input tab below fill out the required fields.
3. Within the email activity is an option to "Add Attachments". Click this and specify the file to attached. Use the browse option to location the location of the file. If the file does not exist yet, specify the location and file name of the file to be created.
How to specify a condition for when to run this activity in an automation job:
In Toad, open Automation under Tools | Automation
1. On the left are activities. System Activities | If...Condition..., double click this to add the activity to the diagram, or the "Toad Automation Script" window.
2. There are 2 sections, one is "If_Condition_1" and "If_Condition_2". Highlight one of the conditions, in the Activitiy Input tab below, build the condition as an expression (i.e. #Execute_1_RCOUNT# >0). This will control whether the activity specified under this condition will run or not.
3. In the diagram, add another activity (i.e. "Send Email" activity) to the automation by clicking and dragging from the list on the left, into the diagram on the right. Drop the activity within the condition, where it notes "Drop Activity Here". This activity will only run if the conditions specified results as a true statement. Set up the added activity accordingly.
Note:
Please refer to Toad's Help | Content, and look up the article regarding "Automate Exception Reporting" for further details about the steps of how to set up an IF condition for your automation that will send out an email if a count is greater then 0. This will be based off a variable set in the "select to file" automation activity.
