If you are using Open Studio (the free version) you won't have TAC. In order to schedule, you will need to use a scheduling tool to run your job. There are loads you can choose from (many open source). If you are using Linux you can use the crontab.
I am not sure what your question 3 really means to be honest. But I will say that when comparing dates you have to consider that dates go down to milliseconds. You have to take this into account when comparing dates. The same day will not necessarily match because days are not the smallest unit of time in a date.
2) whether i need to create separate jobs for load tOralceOutput1 and tOralceOutput2. if yes, how to schedule the jobs before comparing dates and after comparing? orders to run?
3) how to set dependencies between two jobs if required?
table_2: existing data before load table_1 records from excel file. emono, date_col, 1, 18-07-2017 2, 18-07-2017
Scenario: 1) In between tOralceOutput1 and tOralceOutput2, Need to check below logic.
if table_1.date_col <> table_2.date_col wait for process to call ( tOracleInput ------>tOralceOutput2(table_2)
check every 15min continues(infinity loop)
else if table_1.date_col == table_2.date_col continues to next step ( tOracleInput ------>tOralceOutput2(table_2) end if
I am not sure what you are asking now. Unfortunately I don't really have the time to take on the logic of a complete job. You need to try and extrapolate from what people have said and experiment with it. That is the best way to learn. Another thing you need to think about is reducing the scale of your question and not asking another question on the same thread once the first question is answered. First of all that will help the community, since your smaller questions will likely be answered quicker AND other people may have those questions.
I'm not meaning to be mean, I just think that everyone will benefit from working this way. I also think that breaking a problem down into smaller problems helps you to get your head around the bigger problem and understand what you are doing better
