dbms_job

DBMS_JOB is a package in Oracle that allows you to create, schedule and manage jobs. Jobs can be used to automate tasks such as sending out email notifications, running reports, or performing data maintenance.To check the status of a job, you can use the DBMS_JOB.RUN procedure. This procedure takes two parameters: job_name and job_id. The…