AnsweredAssumed Answered

Monthly recurring run for past dates

Question asked by Revathi_Chelladurai_10523 on Mar 20, 2018
Latest reply on Mar 21, 2018 by Wolfgang_Brueckler_1288
Hello
I need to do a monthly historical load from 2015 to 2016. For this I have set up a workflow in UC4 and trying to run it recursively. 

I'm using the run date/batch date, 31/1/2015 or 28/2/2015 in this case, in the sql to filter the records for the respective months. For example: If the batch is running for 31/1/2015, then the sql filter condition would be
sel * from database.tablename where date = {batch date}. 

But the batch_date is resolved as system date instead of batch date. Following are the run time settings for recursive run:

kvsjswqj3ihx.pngwxapf8fx8bzf.png

On the other hand, if I execute the workflow only one with the following setting batch date is correctly resolved to 31/1/2015
ncdy1r5csuba.png

Am I doing anything wrong with the recursive run?

I would really appreciate the help

Thank you

Outcomes