Results 1 to 2 of 2

Thread: Oracle JOB

  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: Oracle JOB

    Hi,
    I need disable the Oracle statistic SYS.GATHER_STATS_JOB for only these days: 27 - 28 and 29 MAY 2013

    If I run:
    HTML Code:
    EXECUTE DBMS_SCHEDULER.DISABLE (name => 'SYS.GATHER_STATS_JOB');
    I disable the JOB but I'd like to disable this job only for 27 - 28 and 29 MAY 2013

    can I disable the job only for a few days?

    if so, can you tell me what step I should do?

    Thanks in advance!

  2. #2
    Join Date
    Jul 2002
    Posts
    227
    I Know that I can create a new named schedule:

    HTML Code:
    dbms_scheduler.create_schedule( schedule_name => 'may_exclude',
    repeat_interval => 'freq=monthly;bymonth=5;bymonthday=27,28,29;byhour=0;byminute=0;bysecond=0',
    comments => 'named schedule to exclude 27,28,29 may');

    but I don't know How can I associate this named schedule "may_exclude" to my job SYS.GATHER_STATS_JOB with EXCLUDE clause

    Have you any idea?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •