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 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.
have u got user guide for Talend.............scheduler is given clearly in it
i referred user guide. but as per my scenario i need to run the job on daily basis at 7 AM. so i need to select day as everyday & hours as 7 Am. but for Month, Day of week & Minutes, whats the value i need to select? if i dont select, its showing error dialogue box.
1) For job1 you open scheduler next to the run icon on talend................add the schedule time using top right
green coloured icon....................repeat this for other jobs also
after completion of doing it..................go to_____ settings__control panel____schedule tasks____select the type of sceduler run_____choose command exe ______schedule the time
yes i referred page 21..........but i have got an experience of working with scheduler...............do u know the procedure of setting schedule tasks in settings icon
no idea.. whats my doubt is for Month, Day of week & Minutes, whats the value i need to give? and also should i again set the schedule by using control panel? when i export the job, does this schedule timings also gets exported or should i write separate script & needs to be executed?
no need to write separate scripts.............u just copy the address of the job in scheduler.........do not give any time or day or week or month.............u copy it for 4 jobs and put in 4 text pads............. then reply me.........i will go for further steps
after this u save all the four text pads in .bat format .............after doing this u will have 4 text pad doc and 4 .bat files...............do it faster
