Edit Question - KnowledgeHub

Title Body

I'm trying to run a scheduled job manually, the job looksa like this DBMS_SCHEDULER.CREATE_JOB ( job_name => 'UPDATE_PLAYER_STATES', job_type => 'STORED_PROCEDURE', job_action => 'PLAYER_STATE_UPDATER', repeat_interval => 'FREQ=DAILY;BYHOUR=0', /* every day at Midnight */ job_class => 'DEFAULT_JOB_CLASS', enabled => true, auto_drop => false); Now when I run the procedure using execute PLAYER_STATE_UPDATER I can see the desired result , but the job is failing to execute as shown by select log_date, job_name, status, run_duration from dba_scheduler_job_run_details where job_name='UPDATE_PLAYER_STATES' or status='FAILED'; LOG_DATE JOB_NAME STATUS RUN_DURATION ------------- ----------------------------------------------------------------- 23-AUG-11 00.20.24.288887000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 22-AUG-11 10.27.24.537659000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 22-AUG-11 10.28.50.447042000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 22-AUG-11 10.30.30.018891000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 25-AUG-11 10.59.02.332579000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 25-AUG-11 10.59.15.980730000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 25-AUG-11 10.59.27.823131000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 25-AUG-11 11.01.04.798364000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 24-AUG-11 00.20.24.419251000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 25-AUG-11 00.20.24.299180000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 25-AUG-11 09.35.24.798535000 +01:00 UPDATE_PLAYER_STATES FAILED 0 0:0:0.0 And executing the job manually is failing too dbms_scheduler.run_job('UPDATE_PLAYER_STATES');</

Tags (comma-separated) Cancel