Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Oracle stops running the timing method

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report