<div>
Here are links:<br />
In a nutshell:<br />
<a href="http://psoug.org/reference/dbms_scheduler.html" rel="ugc">http://psoug.org/reference/dbms_scheduler.html</a><br />
Good explaination with example:<br />
<a href="http://www.oracle-base.com/articles/10g/Scheduler10g.php" rel="ugc">http://www.oracle-base.com/articles/10g/Scheduler10g.php</a><br />
In Depth coverage:<br />
&nbsp;<a href="http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sched.htm" rel="ugc">http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sched.htm</a><br />

</div>


<div>
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?<br />
Is there any dependencies between these MVs?
</div>


<div>
<div class="content wysiwyg-content">
Hi ,<br />
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 &nbsp;the same time and once they &nbsp;have finished successfully they kick off new task &nbsp;via dbms_scheduler. Can you please help me to achieve this via dbms_scheduler in oracle 10g or oracle 11g<br />
<br />
Ta,
</div>
</div>


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,

Here are links:
In a nutshell:
http://psoug.org/reference/dbms_scheduler.html
Good explaination with example:
http://www.oracle-base.com/articles/10g/Scheduler10g.php
In Depth coverage:
 http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sched.htm


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?

dbms_scheduler

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.