oracle schedular job not running (after enabling it)

I created a schedular job in the below way. BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => ‘update_sales_1’, job_type => ‘STORED_PROCEDURE’, job_action => ‘test_job’, start_date => systimestamp, repeat_interval => ‘FREQ=SECONDLY;INTERVAL=10′, end_date => ’20-NOV-2021 07.00.00 PM Australia/Sydney’, auto_drop => FALSE, comments => ‘My new job’); END; / the stored procedure test_job inserts record into a table. After creating the…

Details