How to capture run status of workflow

Hi All, I have two problems.

1) I am using a script to trigger my workflow using below command. and it is running fine.

C:\Program Files\Alteryx\bin>AlteryxService.exe addtoqueue="C:\Users\Admin\Documents\<WorkflowName>",localhost:<Port>,<SecretKey>

I want to perform certain action through my script if workflow fails. Is there a way to know that workflow has failed. does it return something like exit code to the script?

2) I also require to capture run status of the workflow in a oracle table. i.e Status 'Success' is easy to achieve as I can populate the table within the workflow itself with status 'Success'. I am not getting how to put 'Fail' status as if workflow fails it will not update the table either.

Can anyone please help?

Regards

Himanshu

Workflow

Developer Tools

Tips and Tricks

Common Use Cases

Transformation

Dynamic Processing

Preparation

Events

Accepted answers

MichalM

Hi @hima_shar

There's an option to trigger an event (run command or send an email)

After run
After run with errors
After run without errors

To enable this, navigate to the Workflow configuration > Events tab and make sure events are enabled. You can then configure the action you'd like to trigger - this can be anything you can run on a command line so you can run a batch file or another Alteryx workflow depending on an outcome.

An alternative would be the Conditional Runner tool available in the CrEW Macros package.

All comments

MichalM

Hi @hima_shar

There's an option to trigger an event (run command or send an email)

After run
After run with errors
After run without errors

An alternative would be the Conditional Runner tool available in the CrEW Macros package.

hima_shar

@MichalM Thank you for your help. I just tried it. It is working very well. To update the table with failed status, I have created another workflow which runs from command line if original workflow fails (After run with errors).

Regards

Himanshu

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703