27

Oracle 停止正在运行定时方法-技术随笔-51CTO博客

 6 years ago
source link: http://blog.51cto.com/moonstar/2069943
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Oracle 定时任务：1、DBMS_JOBS： dbms_jobs只是jobs对象的一个实例， 就像对于tables， emp和dept都是表的实例。可以通过视图SELECT * FROM DBA_JOBS_RUNNING;来查询停止运行job：dbms_job.broken(jobid,true);2、JOBS：jobs是oracle数据库的对象，由dbms_scheduler.cr

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK