To execute the package
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'RUN_MY_PKG_NOW1',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN xx_text_pkg.insert_stg2; END;',
start_date => SYSTIMESTAMP,
enabled => TRUE
);
END;
To check the Status/Errors after executing the package
SELECT log_id,
status,
error#,
additional_info
FROM user_scheduler_job_run_details
WHERE job_name = 'RUN_MY_PKG_NOW1'
ORDER BY log_id DESC
FETCH FIRST 1 ROW ONLY;
