PL/SQL (MOSC)

MOSC Banner

stored procedure not executed from scheduler job

edited Jul 11, 2014 5:00AM in PL/SQL (MOSC) 1 commentAnswered

I have a scheduler job that executes a stored procedure every minute. It has been working but it doesn't work any more and I have trouble finding why. There were no changes to the database schema. I can run the job manually and I can see the results from the executed job. However, letting it run on schedule shows a '+000 00:00:00' RUN_DURATION and did not produce any results.

BEGIN

  DBMS_SCHEDULER.create_job (

    job_name        => 'GSM_STATS_JOB',

    job_type        => 'PLSQL_BLOCK',

    job_action      => 'BEGIN gsm_stats_proc; END;',

    start_date      => SYSTIMESTAMP,

    repeat_interval => 'freq=minutely;interval=1',

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center