Skip to main content


Scheduling Oracle ODI Load Plans easy as 1, 2, 3

This will probably be one of my shortest posts on ODI, but I figured if I am covering  pretty much all tScreen Shot 2014-08-31 at 2.19.08 AMhe basics of ODI, it would be good to show you how to use ODI’s scheduler and also show you how to schedule your ODI load plans.

As title of the post states “Oracle Data Integrator (ODI) Scheduling Load Plans as easy as 1, 2, 3” this will be a very simple instruction you should all pick up quickly.

1.  Locate the ODI load plan you created. And expand your load plan by clicking on the + sign next to the name of the load plan.  This can be found within the “Load Plans and Scenarios” tab.

Screen Shot 2014-08-31 at 2.20.36 AM

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

2.  Highlight the “Scheduling” option and right mouse click..  Then select New Scheduling.

Screen Shot 2014-08-31 at 2.21.41 AM3.  Within the definition tab you, you will need to enter in execution options such as, “Context, Agent, and Log Level.”  Once you have entered that you will need to select a Status. Here in our example we will leave this “Active.”  Once you have selected your status, then you will need to enter you execution options.  Here you will need to select when you want your load plan to run.  Once the following definitions have been set, click the save button.

Screen Shot 2014-08-31 at 2.22.14 AM4.  Next you will need to click on the “Topology” tab and expand the “Agents” listed under the “Physical Architecture” sub tab.

Screen Shot 2014-08-31 at 2.23.10 AM5.  Select the agent in which you are using to execute your load plan.  Then highlight and right mouse click.  Here a list of options will appear in which you will need to select “Update Schedule.”  This will update the ODI agent to reflect your scheduled changes.

Screen Shot 2014-08-31 at 2.23.48 AM

This will complete the steps to schedule your ODI load plan in ODI.  In addition, to make sure your ODI load plan has been added to the ODI scheduler you can view the scheduler by selecting the “View Schedule” when highlighting and right mouse clicking the ODI agent.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Chris Evans

Chris Evans has extensive management, technical, consulting and customer service skills. He provides hands-on expertise in project leadership and management, assessments, methodologies, data modeling, database design, meta data, systems analysis, and development. He has worked with multiple platforms, and his experience spans a wide range of operational and data warehouse environments. In addition to his BI background, Chris Evans has a experience in marketing strategy for major consumer brands.

More from this Author

Follow Us