the recommended method to Write date end of a job in a variable
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!!
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.
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.
