Hi all,
how do we automate the etl job? i mean, i created a job & i wanna run that job on daily basis, say at morning 7'O clock. is there a possibility to do like this in TOS?
Hi, Export your job(.bat or .sh). You can use windows scheduler if you use windows or generate CronTab String with Tos scheduler if you're using Linux. regards, Youssef
hi youssef, thanks for your response.if you dont mind, could you tell me for windows where i need to set & what do you mean by CronTab String for linux? as am a newbie to TOS, am not much familiar about all the things. could you show me some screenshot?
hi .............after running the job in TOS go to the scheduler option- enter the schedule details- u will find a address location ..............copy that and put it into a text pad................enter pause in the text pad .............save it as a .bat file............after completion go for administrative tools---------scheduler tasks----------set the schedule time and paste the address location..........if u did not get this steps i will send u a screen shot
Hi all, how do we automate the etl job? i mean, i created a job & i wanna run that job on daily basis, say at morning 7'O clock. is there a possibility to do like this in TOS?
hi,
can u please define me the process of defining contexts during runtime of a job..........also i have to define variables..................as i am starting using of Talend now please send me some scenarios and materials
regards
bhanu
Hi youssef & bhanu
thanks for your response. in talend i've created 4 jobs & i wanna run those jobs one after other. i cannot join those by using tRunJob, as ony one job throws error also next job needs to be continued. so daily morning 7AM my jobs needs to be executed automatically. could anyone please show me the screenshot. so that it'll be much understable.
can u send me the scenario u built so tat i will send the details accordingly..............u mean to say..........u should run the scheduler continously ..........right
Hi bhanu,
the following is the scenario for my jobs.
job 1: parsing the input files & loading into DB public schema (Postgres)
job 2: extracting data from public schema & loading into main schema
job 3: extracting data from Postgres & loading into Oracle
job 4: updating Postgres tables based on loaded data in Oracle
yes exactly. i need to start the scheduler for the first job & it should continue till the last job on daily basis.
hi check the documentation user guide...............talendug 3.0 a...........steps were given clearly ...............if difficult to down load send me the mail id i will send it
