Configuring the Email Alerts that should display the dynamic values

Question

Hi All,

I would like to configure the Email alerts after the successful / failure of the Alteryx job which should display dynamic values to the recipients with the below mentioned template.

Subject:[Success/Failure] [Today's datetime] [Solution name] [Job name]
Body :
Dashboard/Solution name :
Job name:
Job frequency:
Job start date time: Job end date time:
Job duration:
Job status:
No of rows processed:

Any suggestions is much appreciated...!

Thanks in Advance

Tam · Answer

Hi Sagar

Scan down the log and output the value you need (you can use regex if you know how to. To me regex is like reading latin) put these values into the text input in the attached example work flow.

Subject:[Success/Failure] you need to define what is success or failure [Today's datetime] row 8 [Solution name] row 8[Job name] row 3
Body :
Dashboard/Solution name : row 8
Job name: row 3
Job frequency: not really sure what you mean ? 
Job start date time: row 8 Job end date time: calculated from row 8  and row 17 
Job duration: row 17
Job status: You will need to define this from row 4 to 6 
No of rows processed: Sum of Row 9 and row 14

log.PNG

log2.PNG

Configuring the Email Alerts that should display the dynamic values 2.yxmd

Sagarloknath · Answer

@Tam

Thank you for the suggestion,

I have downloaded the log file. Would you mind tell me what is the next procedure to send an email with the modified template. If you can send me the workflow that would be great.

Regards,

Sagar

Tam · Answer

@Sagarloknath ok got it.

If you can access the path where the %OutputLog% are kept you could read it using a dynamic input tool and then it's a matter of parsing the info required to generate an email.

Enable Logging via System Settings
To enable logging via System Settings, you need to be an Administrator user. If you're an Admin user...

In System Settings, navigate to Engine > General.

In the Logging Directory field, specify a directory where you want to capture the output logs that are produced each time a workflow or app runs.

To disable logging, leave the Logging Directory field blank.

Enable Logging via User Settings
You can also enable logging via Alteryx Designer's User Settings. To enable logging via User Settings...

In Designer, navigate to Options > User Settings > Edit User Settings.

In the User Settings Defaults tab, select the Override System Settings check box.

In the Logging Directory field, specify a directory to capture the output logs that are produced each time a workflow or app is run.

To disable logging, leave the Logging Directory field blank.

HTH

Tam