Is there an error logging or notification option in Automation? (4229242)

Is there an error logging or notification option in Automation?

Is there an error logging/notification option in Automation?

If there is a problem with the automated job is it possible to be notified of this and sent details of the problem when it occurs?

RESOLUTION:

When creating/editing the automation job, there is the section for "Script Settings" in the Automation Script gui. Click on this and set the activity properties.

1. Send Email on Error --- True
2. Attach Log File to Email --- True
3. Set email and server information
4. Logging level --- Verbose

With "Send Email on Error" and "Attach Log File to Email" enabled, the messages logged for the Automation job run will be logged to a file.

The location of the file can be specified in the "Logging Folder" field. Default is set to C:\Users\<personal folder>\AppData\Roaming\Quest Software\Toad Data Point <version>\Automation (or Automation Publishing).

The name of the log file should be the same as the name of the automation job you're running. If these settings are not enabled, the log will not be saved to file. If the settings are disabled for the automation job, the log file will be removed from the noted Automation directory. 

For the individual activities specified in the automation, some may have a check box to enable or disable the option to "Stop on error" in the Activities Info tab. Please make sure you set these accordingly also. If the check box is marked, Toad will stop the automation if there is an error that occurs in this activity. It will not continue on to the other activities in the Automation script. If the check box is not marked, Toad will error out and continue with the rest of the Automation script. Please also note, under Script Settings for the automation on the Activities Input tab, there are toggle buttons for "Stop on error" or "Continue on error". This is a general toggle option to set all or none for all the "Stop on error" check box in each activity. If the "Stop on error" is enabled in Settings, all the "Stop on error" check boxes in each Activity is enabled. If the "Continue on error" are enabled in Settings, all the "Stop on error" check boxes in each Activity are disabled. Note, while this may be toggled on to "Stop on error" in this Settings details, the specific setting in each Activities | Activity Info check box for "Stop on error" is what defines the action of the automation script.