Oracle stops running the timing method
Oracle scheduled tasks:
1 、 DBMS_JOBS:
Dbms_jobs is just an instance of a jobs object, just as for tables, emp and dept are both instances of a table.
You can use the view
SELECT * FROM DBA_JOBS_RUNNING
To inquire.
Stop running job:
Dbms_job.broken (jobid,true)
2 、 JOBS:
Jobs is the object of the oracle database, which is created by the package dbms_scheduler.create_job, even if you use program,scheduler to configure job
Through the view
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS
To inquire.
Stop running Job:
EXEC DBMS_SCHEDULER.stop_job ('JOB name')
Note: when I am executing, I need to execute EXEC DBMS_SCHEDULER.stop_job ('JOB name') on the command line of the current user to stop JOB.
