When the job has finished succesfully, i want to save via tPostgreSQLSP (myLogFunction (date, date)) the job start and end -datetime- How do i retrieve those variables and send them to my tPostgreSQLSP when the job has finished? Regards
Hi, you can use tChronometerStart and tChronometerStop components to catch start and end date. if you have a java project manipulate those variables to deduce your end date : ((String)globalMap.get("tChronometerStop_1_DURATION")) // tChronometerStart_1 is the name of your Start componenent ((String)globalMap.get("tChronometerStart_1_STARTTIME")) //tChronometerStop_1 is the name of your Stop componenent
And if i don't have a java project, im just using a talend job... After the chronometer stop, can i use any component to get those variables and then send them to my tpostgreSQLSP?