I have created the following job,
BEGIN
-- Job defined entirely by the CREATE JOB procedure.
DBMS_SCHEDULER.create_job (
job_name => 'Update_Status',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN ;updateStatus; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=minutely; bysecond=0;',
end_date => NULL,
enabled => TRUE,
auto_drop => FALSE,
comments => 'Job defined entirely by the CREATE JOB procedure.');
end;
When I look for the status of the job in the following table
SELECT *FROM USER_SCHEDULER_JOB_LOG
The Status field shows Failed. How to make my job runnable what could be reason. Please help to solve this problem.