ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Scheduling using ODI Scheduler

Start the agent using agent scheduler or agent service

Scheduling process

Under the  scenario , right click on scheduling , click on " Insert scheduling "

Define all the scheduling parameter and the logical agent and log level. Set the Execution mode and Execution time and period. For more choice look for other tabs.Finally apply your setting and click ok.

To apply Scheduling , Go to  Topology – > Logical Architecture – > Logical Agent

Right click on Logical Agent and Click on the " Update Scheduling " .

[ Note: Make sure the agent is running  as ODI scheduler needs the agent  for its functionality . ]

14 Comments

  1. Hi ODI Experts,

    I scheduled a scenario for executing every 15 minutes. It’s working fine, but ODI scheduler waits 15 minutes for next execution of the scenario. It is not including the execution time and waiting time.

    Let me explain you with an example for clear understanding, I have scheduled a scenario (for every 15 minutes) at 9 AM. Scenario starts execution at 9 AM and it took 240 seconds (i.e 4 minutes) for completion of execution, it means execution of scenario ends at 9:04 AM then it waits for 15 minutes and then it starts the next execution at 9:19 AM.

    But this should not happen, the next execution should start at 9:15 AM ( Scheduler should include execution and waiting time).

    Please help me how i can overcome this.

    Thanks & Regards,
    Shiva Kumar

    • Hi Shiva Kumar,

      Thank you for your comments. It helped.
      I have a similar requirement:
      1. There are two different environments.
      2. In Env 1 if load is completed. Then we need to create a trigger to automatically start Load in Env 2.
      Can you please give idea on this.

      Thanks,
      Dinesh T.

    • Please bounce your ODI agent and try the same process.
      There can be a lag which gets developed over the period of time.

      Please retry.

  2. can someone tell me how we can schedule the scenarios bi weekly?

  3. How can one schedule ODI to run a scenario after a given number of minutes?

  4. how to get scheduler date and time in parameter of ODI schedule input

  5. I found this very helpful, thank you.

    I also found that the path is not as defined:

    To apply Scheduling , Go to Topology – > Logical Architecture – > Logical Agent

    And Rather:
    To apply Scheduling , Go to Topology – > Physical Architecture – > Logical Agent

    Thanks-
    Mike

  6. Hi,
    i had a problem yesterday for a first time with my scheduled scenario execution, and now i have some doubts about number of attempts on failure option in Execution Cycle tab in Scenario Scheduling. There is a posibility that my extraction scenario will not be executed because of network problems, so i would consider in using option Number Of Attempts on Failure (Constraints). What i couldn’t find in documentation was time delay between attempts. So basically i would like to set execution in 3am, and if network is down, scenario would try and execute every 10 minutes, 20 times.
    Thanks,
    Tomo

  7. Is there a way I can run a scenario every 10 mins (mini batch) or so using ODI not using Crontab.

    Thanks,
    Mandeep

  8. Can you explain how to do scheduling on linux O.S?

    Thanks,
    Sameer

    • In unix you can schedule using Crontab (or )any other external scheduler
      Easy way is to Create a small shell script and call the required ODI environment variables ,then startscen.sh with required parameters and finally test the shell script and then call that script in crontab or through any external scheduler.

      Hope this helps.

      • Hi Devendra,

        Thank you for your comments. It helped.
        I have a similar requirement:
        1. There are two different environments.
        2. In Env 1 if load is completed. Then we need to create a trigger to automatically start Load in Env 2.
        Can you please give idea on this.

        Thanks,
        Dinesh T.

  9. It is given very clearly about the agent scheduling. Please let me know how can we achive parallelism in ODI with Agents. That is when there is a certain amount of work that work has to be shared equally among the multiple agents.

    Let me know if there is any doc which i can follow.

    Thanks in Advance,
    MansurAulam

Leave a Reply

Required fields are marked *.