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?
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.