Adobe Campaign Classic V8 - Get a workflow execution time.

[bsm11]

Hi Team,

I'd like to know how we can have details below (only for scheduled workflows):

• Workflow start date - Can we consider Last Processing time from xtk:workflow schema [As we don't have any direct attribute for the same]
• Workflow end date - Can we consider the 'last modified date'.
• A workflow execution time.

[LakshmiPravallika]

Hi @bsm11 

Yes, we can consider the @processDate as Last execution start time of the workflow , however the @lastModified field would be impacted if any manual changes are made to the workflow and it would get Updated.

In order to get the workflow execution time, we can consider the logs from the "xtk:workflowLog" schema, which gives us the actual start time and run time of the workflows.

Regards,

Pravallika, 

[bsm11]

Thanks for a quick reply, Lakshmi. Helpful.

I do agree with @lastModified date.

But, regarding start and end, you was trying to say, we can use "Message" column from "xtk:workflowLog" schema, as there was no other relevent attribute/fields are available. Please confirm.

Regards,

Broja

[ccg1706 · Accepted solution]

Hi @bsm11,

Yes, that's correct Broja. As @LakshmiPravallika mentioned, the xtk:workflowLog schema is the right place to check, you can use the message and logDate field to identify when the workflow started and ended, since there's no direct attribute for those timestamps.

Best, 

Celia

[bsm11]

Thanks for the confirmation, Celia. I already used this approached.

Regards,

Broja