oracle 如何知道批处理作业是否正在运行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9024777/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to know if batch job is running
提问by Em Ae
I have an oracle batch job which runs every 15 min. For some reasons, there might be possibility that the business logic being executed in batch job, might take more than 15 minutes. Is there any possible way i can check if the batch job is still in process ?
我有一个每 15 分钟运行一次的 oracle 批处理作业。由于某些原因，在批处理作业中执行的业务逻辑可能需要超过 15 分钟。有什么可能的方法可以检查批处理作业是否仍在处理中？
i.e.
IE
batch job runs (process 1) takes 20 min after 15 min, the same batch job runs (process 2) .. I want to check if the batch jobn with this name is already in running or not.
批处理作业运行（进程 1）在 15 分钟后需要 20 分钟，相同的批处理作业运行（进程 2）.. 我想检查具有此名称的批处理作业是否已经在运行。
there is a procedurewhich copies large chunk of data from one record to other. this procedure is being executed every 15 minutes by using dbms_scheduleri.e. DBMS_SCHEDULER.CREATE_SCHEDULER, creating program using DBMS_SCHEDULER.CREATE_PROGRAMand using these 2 in DBMS_SCHEDULER.CREATE_JOB
有一个procedure将大块数据从一个记录复制到另一个记录。此过程每 15 分钟执行一次，方法是使用dbms_schedulerie DBMS_SCHEDULER.CREATE_SCHEDULER，使用DBMS_SCHEDULER.CREATE_PROGRAM和使用这两个来创建程序DBMS_SCHEDULER.CREATE_JOB
回答by grokster
select * from all_scheduler_running_jobs;
回答by someuser2
Try select * from [dba_scheduler_jobs][1];and look at the state column for your job.
尝试select * from [dba_scheduler_jobs][1];查看您工作的状态栏。
