DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dbms_scheduler time problem

  1. #1
    Join Date
    Oct 2008
    Posts
    69

    dbms_scheduler time problem

    Hi There, i have been trying to set up a job to run through dbms_scheduler fpr the first time. Everything appears to load in ok but when i check dba_scheduler_jobs the date looks like scheduled for 2020 rather than 2009

    Note this is just a test to get working, i am not actually only going to run this once on a friday, just need to see it work first before tailoring.

    Code:
    begin
    dbms_scheduler.create_schedule(
       schedule_name => 'phil_schedule'
      ,start_date => '08/MAY/2009 12:00:00'
      ,repeat_interval => 'FREQ=WEEKLY'
      , comments => 'Weekly on Fri at 12');
    END;
    / 
    
    begin
       dbms_scheduler.create_job
       (
          job_name      => 'ifstest_statspack',
          schedule_name => 'phil_schedule',
          job_type      => 'EXECUTABLE',
          job_action    => '/home/oracle/statspack/scripts/ifstest-statspack.sh',
          enabled       => true,
          comments      => 'Run shell-script'
       );
    end;
    /
    I have had this set and the time comes and goes and nothing happens. I go to check dba_scheduler_jobs and it tells me that the start date is the following

    08-MAY-20 09.12.00.000000 +01:00

    That looks like 2020 to me
    if i try creating the schedule with dates in format
    start_date => '08/MAY/09 12:00:00'
    or
    start_date => '2009/MAY/08 12:00:00'
    i get errors about date too short or invalid month

    I just want to check i am not barking up the wrong tree, that does say 2020 yeah? What do i do to fix this?
    I have read i could set NLS_DATE_FORMAT but this could interfere with other things (other peoples scripts?)

    Anyone have any suggestions?
    Thanks in advance.
    ps this is Oracle 10.2.0.1 on Solaris 10

    P

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool To_date()

    Try:

    Code:
    -- Etc --
     ,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
    -- Etc --

    PS: Not sure if you need outer single or double or no quotes.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2008
    Posts
    69
    Quote Originally Posted by LKBrwn_DBA View Post
    Try:

    Code:
    -- Etc --
     ,start_date => TO_DATE('08/MAY/2009 12:00:00','DD/MM/YYYY HH24:MI:SS')
    -- Etc --

    PS: Not sure if you need outer single or double or no quotes.
    Thanks, that worked just as you wrote it.

Posting Permissions

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


Click Here to Expand Forum to Full Width