dbms_scheduler

Hi ,
We have three materialize views runs everyday and each took 8 hr to finish . We want to run them in go i.e. all to run at  the same time and once they  have finished successfully they kick off new task  via dbms_scheduler. Can you please help me to achieve this via dbms_scheduler in oracle 10g or oracle 11g

Ta,
Prashant0906Asked:
Who is Participating?
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
We have three materialize views runs everyday and each took 8 hr to finish . --> Do you mean the refresh of MV.

You can have 3 jobs scheduled in scheduler to refresh the MV's and then another job to start once all these three are finished. You can create dependent schedules as well if you read through the documentation of scheduler.

Let us know if you need any additional help.

thanks
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
What is the other task. is that task can only be called when all of three refresh finishes or every task is associated with MV?
Is there any dependencies between these MVs?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.