This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Feb 6, 2013 3:59 AM by 989463 Go to original post RSS
  • 15. Re: DBMS scheduler
    846231 Newbie
    Currently Being Moderated
    Hi Osama,

    Wait, I run first the above and test while you are still there :)

    Just a clarification:

    Your batch code is
    begin
    dbms_scheduler.create_job (
    job_name =>'DROP_DB_LINK',
    job_type =>'executable',
    job_action => '<PATH>.bat >',
    start_date      => SYSTIMESTAMP,
     repeat_interval => freq=daily; byhour=0; byminute=0; bysecond=0;
    enabled => true,
    );
    commit;
    end;
    / 
    While Veeresh code is
    BEGIN
    SYS.DBMS_SCHEDULER.CREATE_JOB(
    job_name => 'refresh_link',
    job_type => 'EXECUTABLE',
    job_action => 'C:\WINDOWS\system32\cmd.exe',
    start_date => SYSTIMESTAMP,
    repeat_interval => 'freq=daily; byhour=0; byminute=0; bysecond=0',
    number_of_arguments => 2,
    end_date => NULL,
    enabled => TRUE,
    comments => 'refresh db links');
    SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE(
    job_name => 'refresh_link', argument_position => 1, argument_value => '/c');
    SYS.DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE(
    job_name => 'refresh_link', argument_position => 2, argument_value => '"d:\RefreshDblink.bat"');
    END;
    /
    Your job action is ==== > '<PATH>.bat >' ## does it refers to d:\RefreshDblink.bat?

    Veeresh has =====> 'C:\WINDOWS\system32\cmd.exe' ## is this default or mandatory as I am running a windows .bat as the type of exe?


    Which job_action is correct?


    Thanks
  • 16. Re: DBMS scheduler
    846231 Newbie
    Currently Being Moderated
    Thanks veeresh :D that is better and clearly explained.
  • 17. Re: DBMS scheduler
    989463 Newbie
    Currently Being Moderated
    Hi All,

    I have an issue related to logging date written by a maintenance window job.
    Job is a nightly job scheduled to run at 2:00 AM

    A log file is created from this Job run.
    Timestamp is written into this log file using UTL_FILE.PUT_LINE(log_file,TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI:SS'))

    when i do "ls -l logfile" , the correct time is shown ( 2:00 AM )
    but when i open logfile and view timestamp written with SYSDATE, wrong time is seen ( 14:00 etc..)

    could someone tell what could be wrong ?
    Oracle release is 11.2.0.2 ( system is Unix 32 bit )

    P.S.- I am replying on this thread as i don't know how to create a new thread
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points