oracle dbms_scheduler并行运行多个过程 [英] oracle dbms_scheduler to run multiple procedures in parallel

问题描述

我试图找出oracle的DBMS_SCHEDULER(Oracle 11g)，并且需要帮助来设置以下内容:

I've trying to figure out oracle's DBMS_SCHEDULER (Oracle 11g) and need help setting up the following:

我有一个过程可以调用其他过程列表，如下所示:

I have a procedure that calls a list of other procedures like this:

CREATE OR REPLACE
PROCEDURE RUN_JOBS AS
BEGIN
  MYUSER.MYPROCEDURE1();
  MYUSER.MYPROCEDURE2();
  MYUSER.MYPROCEDURE3();
  MYUSER.MYPROCEDURE4();
  MYUSER.MYPROCEDURE5();
END;
/

我想使用DBMS_SCHEDULER运行MYPROCEDURE3()，MYPROCEDURE4()，MYPROCEDURE5() 完成MYPROCEDURE2()后，以 parallel 进行.

I would like to use DBMS_SCHEDULER to run MYPROCEDURE3(), MYPROCEDURE4(), MYPROCEDURE5() in parallel after the completion of MYPROCEDURE2().

有人可以给我看一个如何设置它的例子吗?

Can someone show me an example on how to set this up?

推荐答案

您可以参考DBMS_SCHEDULER软件包下的Chains:

You can refer to Chains under the DBMS_SCHEDULER package: http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm

您还可以通过Oracle Enterprise Manager来实现相同的目的，但是我现在找不到指向文档的任何链接.

You can also achieve the same by going through Oracle Enterprise Manager, but I can't find any links to documentation right now.

这篇关于oracle dbms_scheduler并行运行多个过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！