Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 722
  • Last Modified:

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,
0
Prashant0906
Asked:
Prashant0906
1 Solution
 
Naveen KumarProduction 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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now