如何同时运行两个或多个oracle作业实例? [英] How run two or more instances of an oracle job in the same time?

问题描述

我已经定义了一个函数，当该函数被调用时它将使用以下命令定义一个oracle作业

I have defined a function that when it is called it will define an oracle job with

dbms_scheduler.create_job

运行带有参数的store_procedure

that runs a store_procedure with arguments

my Function
Begin
    job created and executed from here
end;

我的问题是，当我的一个作业实例正在执行时，我无法执行该作业的另一个实例. 如我所说，我的工作执行的是带有参数的store_procedure，所以我想同时用不同的参数值执行该作业，但我不能. 有什么财产或方式可以帮助我做到这一点吗?

My problem is that when an instance of my job is executing I can not execute another instance of that job. as I said my jobs executes a store_procedure that have arguments so I want to execute that job with different values of arguments in the same time but I can not. is there any property or way that can help me to do this?

推荐答案

提供创建随机名称的作业.

Give the jobs you create random names.

这篇关于如何同时运行两个或多个oracle作业实例?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！