the recommended method to Write date end of a job in a variable

[Ba09]

Hello,

I consume a csv file filled with the values ​​of the context variables that I load them with the tLoadContext component in the prejob and afterwards in the post job part I could not insert the value of the end date of the job execution in the same csv file, the error I got:

The process cannot access the file because this file is in use by another process!!

[Ba09]

So have you a recommanded method to set Last_Date_Out : contains last execution date than i get this date to filter my data from database?

[Anonymous · Accepted solution]

Hi

In the end of job, get the current date and write it to the CSV file, eg:

bababa

|onsubjobok

tFixedFlowInput--main--tfileOutputDelimited

on tFixedFlowInput: define the columns you want to write the file, maybe you need to rewrite all context variables, for the last execution date, you can get the current date with expression:

column: value

columnName:TalendDate.getCurrentDate()

let me know If you still have errors, and share a screenshot of your job.

Regards

Shong