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

Thread: problem facing with dbms_scheduler

  1. #1
    Join Date
    Apr 2010
    Posts
    12

    problem facing with dbms_scheduler

    exec dbms_scheduler.create_job(JOB_NAME=>'TESTING',JOB_TYPE=>'STORED_PROCEDURE',JOB_ACTION=>'TEST1',NUMBER_OF_ARGUMENTS=>1,START_DATE=>TO_TIMESTAMP('19-SEP-2010 16:57:00','DD-MON-YYYY HH24:MI:SS'),END_DATE=>TO_TIMESTAMP('19-SEP-2010 17:05:00','DD-MON-YYYY HH24:MI:SS'),REPEAT_INTERVAL=>'FREQ=HOURLY;BYMINUTE=2',AUTO_DROP=>FALSE);

    exec dbms_scheduler.set_job_argument_value('TESTING',1,'16');
    EXEC DBMS_SCHEDULER.ENABLE('TESTING');
    .............
    I have executed the scripts in the above specified format, but i don't know why job didn't get fired.

    everything is showing in dba_Schduler_jobs.

    am i missed something here.

    please help me.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Please exec and post...

    SELECT * FROM dba_scheduler_jobs WHERE job_name = 'TESTING';
    SELECT * FROM dba_scheduler_job_log WHERE job_name = 'TESTING';
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Apr 2010
    Posts
    12
    [QUOTE=PAVB;265813]Please exec and post...

    SELECT * FROM dba_scheduler_jobs WHERE job_name = 'TESTING';


    SELECT * FROM dba_scheduler_job_log WHERE job_name = 'TESTING';[/QUOTE

    DBA_SCHEDULER_JOBS OUTPUT....

    JOB_NAME START_DATE JOB_TYPE JOB_ACTION END_DATE REPEAT_INTERVAL STATE ENABL AUTO_
    ---------- ----------------------------------- -------------------- -------------------- ----------------------------------- ------------------------- --------------- ----- -----
    TESTING 19-SEP-10 04.57.00.000000 PM +05:30 STORED_PROCEDURE TEST1 20-SEP-10 05.05.00.000000 PM +05:30 FREQ=HOURLY;BYMINUTE=2 SCHEDULED TRUE FALSE
    ----------------------------------------------
    DBA_SCHEDULER_JOB_LOG:-

    NO RECORDS FOR THIS JOB.

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