This discussion is archived
2 Replies Latest reply: Dec 10, 2012 4:40 AM by JeromeFr RSS

Event Base Scheduling In ODI

Papai Newbie
Currently Being Moderated
Hi,
I have two question:-
1) is there any concept like event based scheduling in odi??

2)I have two two scenario scheduled at different time.I want if the first scheduling is complete the next scheduleing will start(otherwise not).Is it possible in odi?
If yes then please reply how??

Thanks
  • 1. Re: Event Base Scheduling In ODI
    A. Drieux Pro
    Currently Being Moderated
    1) You can use some tools in your package that wait for the event. Ex : "Odi File Wait" (the event is a file) ; "Odi Wait for Data" (the event is an satisfied SQL Statement ) ; ODI Wait for Child Session (the event is another ODI Session)

    Your ODI scenario will be always in "run state", but it will just wait the event before executing the data flow.


    2) I assume you can do this with LOAD PLAN (available in ODI 11g)
  • 2. Re: Event Base Scheduling In ODI
    JeromeFr Expert
    Currently Being Moderated
    Hi,

    2) If you don't want to use load plan, you can also store the last execution in DB at the end of you first scenario if everything is ok. When launching the second, add a first that check that the date stored is the same as TRUNC(sysdate). You can also retrieve the last execution in the work repository.



    Regards,
    JeromeFr

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points