<legend id='zxXUy'><style id='zxXUy'><dir id='zxXUy'><q id='zxXUy'></q></dir></style></legend>
    <i id='zxXUy'><tr id='zxXUy'><dt id='zxXUy'><q id='zxXUy'><span id='zxXUy'><b id='zxXUy'><form id='zxXUy'><ins id='zxXUy'></ins><ul id='zxXUy'></ul><sub id='zxXUy'></sub></form><legend id='zxXUy'></legend><bdo id='zxXUy'><pre id='zxXUy'><center id='zxXUy'></center></pre></bdo></b><th id='zxXUy'></th></span></q></dt></tr></i><div id='zxXUy'><tfoot id='zxXUy'></tfoot><dl id='zxXUy'><fieldset id='zxXUy'></fieldset></dl></div>
  1. <small id='zxXUy'></small><noframes id='zxXUy'>

  2. <tfoot id='zxXUy'></tfoot>

    • <bdo id='zxXUy'></bdo><ul id='zxXUy'></ul>

    1. 如何在窗口中安排 Oracle DBMS 作业

      How to schedule Oracle DBMS Jobs in a window(如何在窗口中安排 Oracle DBMS 作业)
      <tfoot id='6plIy'></tfoot>
        <tbody id='6plIy'></tbody>
            <bdo id='6plIy'></bdo><ul id='6plIy'></ul>
              <i id='6plIy'><tr id='6plIy'><dt id='6plIy'><q id='6plIy'><span id='6plIy'><b id='6plIy'><form id='6plIy'><ins id='6plIy'></ins><ul id='6plIy'></ul><sub id='6plIy'></sub></form><legend id='6plIy'></legend><bdo id='6plIy'><pre id='6plIy'><center id='6plIy'></center></pre></bdo></b><th id='6plIy'></th></span></q></dt></tr></i><div id='6plIy'><tfoot id='6plIy'></tfoot><dl id='6plIy'><fieldset id='6plIy'></fieldset></dl></div>

              1. <legend id='6plIy'><style id='6plIy'><dir id='6plIy'><q id='6plIy'></q></dir></style></legend>

                <small id='6plIy'></small><noframes id='6plIy'>

              2. 本文介绍了如何在窗口中安排 Oracle DBMS 作业的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                我想创建一个每周日(不是周末)从 09:00 到 20:00 每 10 分钟运行的 Oracle DBMS 作业.我想知道我是否可以在作业定义的 FREQ 参数中做到这一点,或者我必须创建一个 New Maintenance Window.

                I want to create an Oracle DBMS Job that runs every week day (not on weekends) from 09:00 to 20:00 every 10 min. I wonder if I can do that in the FREQ parameter of the job definition or I have to create a New Maintenance Window.

                似乎在提出的解决方案中,作业仅在 9 和 20 运行,并且在第一次执行后,当我运行此查询时

                It seems that with the solution proposed, the job runs at 9 and 20 only, and after first execution, when I run this query

                select owner, job_name, next_run_date 
                from dba_scheduler_jobs 
                where JOB_NAME = 'GET_INVOICES_JOB';
                

                我收到了 09/10/17 20:01:27,000000000 欧洲/马德里

                'freq=minutely; interval=10; byhour=9,20; byday=MON,TUE,WED,THU,FRI; exclude=Company_Holidays; bysetpos=-1'
                

                推荐答案

                你可以使用这个:

                begin
                dbms_scheduler.create_job (
                   job_name           =>  'jb_en_lopes',
                   job_type           =>  'STORED_PROCEDURE',
                   job_action         =>  'pr_en_lopes',
                   start_date         =>  '09-oct-2017 09:00:00 am',
                   repeat_interval    =>  'freq=minutely; interval=10; byhour=9,10,11,12,13,14,15,16,17,18,19,20; byday=MON,TUE,WED,THU,FRI;',
                   enabled            =>  true);
                end;
                

                当这个调度器负责时,我得到以下结果:

                When this scheduler in charge I get the results below :

                select * 
                  from dba_scheduler_job_log l
                 where l.job_name = 'JB_EN_LOPES'
                 order by l.log_date desc;
                
                 LOG_ID LOG_DATE                            OPERATION   STATUS
                
                1051594 10-OCT-17 09.59.01.197420 AM +03:00    RUN      SUCCEEDED  
                1051592 10-OCT-17 09.58.02.229724 AM +03:00    RUN      SUCCEEDED  
                1051590 10-OCT-17 09.57.03.177907 AM +03:00    RUN      SUCCEEDED  
                1051588 10-OCT-17 09.56.01.197341 AM +03:00    RUN      SUCCEEDED
                

                哪里:

                select owner, job_name, next_run_date                                  
                  from dba_scheduler_jobs                                               
                 where JOB_NAME = 'JB_EN_LOPES'; 
                
                 OWNER    JOB_NAME       NEXT_RUN_DATE
                
                 myschema JB_EN_LOPES   10-OCT-17 08.00.00.194958 PM +03:00
                

                更新:

                如果您无权访问 dba_ 视图,请考虑将这些前缀替换为 user_,并从选择列表中删除 owner 列对于最后一个查询

                If you have no access to dba_ views, then consider to replace those prefixes with user_, and remove owner column from the select list for the last query as

                select job_name, next_run_date                                  
                  from user_scheduler_jobs                                               
                 where JOB_NAME = 'JB_EN_LOPES'; 
                

                这篇关于如何在窗口中安排 Oracle DBMS 作业的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                相关文档推荐

                How to call Oracle function or stored procedure using spring persistence framework?(如何使用 Spring 持久化框架调用 Oracle 函数或存储过程?)
                What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors(什么会导致间歇性 ORA-12519(TNS:找不到合适的处理程序)错误)
                SQL to return the number of working days between 2 passed in dates(SQL 返回两个传入日期之间的工作日数)
                Oracle Date Subtraction(Oracle 日期减法)
                Is using quot;select *quot; for a cursor in PL/SQL considered bad programming?(正在使用“选择 *PL/SQL 中的游标被认为是糟糕的编程?)
                Using sql/plsql, how do you find out which character set a text uses?(使用 sql/plsql,你如何找出文本使用的字符集?)

                      <tbody id='NtYnF'></tbody>

                    <tfoot id='NtYnF'></tfoot>
                      <legend id='NtYnF'><style id='NtYnF'><dir id='NtYnF'><q id='NtYnF'></q></dir></style></legend>
                          <bdo id='NtYnF'></bdo><ul id='NtYnF'></ul>

                          <i id='NtYnF'><tr id='NtYnF'><dt id='NtYnF'><q id='NtYnF'><span id='NtYnF'><b id='NtYnF'><form id='NtYnF'><ins id='NtYnF'></ins><ul id='NtYnF'></ul><sub id='NtYnF'></sub></form><legend id='NtYnF'></legend><bdo id='NtYnF'><pre id='NtYnF'><center id='NtYnF'></center></pre></bdo></b><th id='NtYnF'></th></span></q></dt></tr></i><div id='NtYnF'><tfoot id='NtYnF'></tfoot><dl id='NtYnF'><fieldset id='NtYnF'></fieldset></dl></div>
                        • <small id='NtYnF'></small><noframes id='NtYnF'>