I have one query, I have written a CRON job it’s work is to read multiple text file and write that data to a CSV file. This read and write is performed via SFTP.
Created CSV File name : xyzA000101.csv
Where A0001 is seperate value and 01 is a seperate value
Now my scenario.
My cron job is running at an interval of 2h, so whenever it will run it will create a file with the name format xyzA000101.csv
So say my file sequence will follow the pattern.
I am incrementing the value of A0001 and 01 equals to the number of times file created on SFTP.
I have defined the counter inside activity.
so if suppose because of some reason I have to take the restart then my counter value will be lost.
And whenever I take a restart a new workflow of cron is created with new id.
So could you please suggest how can I retain my last counter value if restart is taken. Because I wanted to retain that last value and use it. Or I should not create a new cron every time I take a restart what is better for my solution please suggest.