In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.