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 . ]
April 3, 2018 at 5:44 PM
Hi ODI Exports,
I am new to ODI I have one issue, We scheduled Essbase data load jobs in ODI operator every week starting and sometimes “Enable DB connection failed“ issue happening when we restart the server and re-ran the odi jobs its working fine, how can we prevent this issue. Could you please help for this.
Thanks in Advance,
Raghu
February 17, 2017 at 6:07 PM
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
February 20, 2017 at 5:09 PM
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.
March 30, 2017 at 4:23 AM
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.
November 21, 2017 at 4:07 PM
Hi Could you tell me how are you achieving this every 15 mins execution through ODI scheduling? Urgently need the solution for an implementation
November 21, 2017 at 4:29 PM
Hi,
the simplest way is to create 4 hourly scheduling starting at minutes 00 – 15- 30 – 45 but in this way it could launch the process more than one time if the previous didn’t finish.
Other way is to put an interval between executions in just one scheduling.
April 2, 2019 at 11:27 AM
Hi Shiva Kumar,
I have a similar requirement, how did you resolve the issue please let me know.
Thanks,
Raavi
October 28, 2016 at 7:24 PM
can someone tell me how we can schedule the scenarios bi weekly?
October 13, 2016 at 6:30 PM
How can one schedule ODI to run a scenario after a given number of minutes?
July 28, 2014 at 3:08 PM
how to get scheduler date and time in parameter of ODI schedule input
November 30, 2010 at 1:34 PM
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
November 30, 2010 at 7:46 PM
Thanks Mike for pointing out that , its updated.
November 25, 2010 at 10:17 AM
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
October 26, 2010 at 8:58 AM
Is there a way I can run a scenario every 10 mins (mini batch) or so using ODI not using Crontab.
Thanks,
Mandeep
September 28, 2010 at 5:48 AM
Can you explain how to do scheduling on linux O.S?
Thanks,
Sameer
September 28, 2010 at 11:05 AM
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.
February 20, 2017 at 5:06 PM
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.
October 19, 2009 at 9:22 AM
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