而实际中线上oracle库的jobs是存在user_scheduler_jobs表里面的,我通过sql进行查询,如下所示:
SQL> select job_name,job_style,job_creator from user_scheduler_jobs; JOB_NAME JOB_STYLE JOB_CREATOR ------------------------------ ----------- ------------------------------ JOB_23 xx xx JOB_61 xx xx JOB_20 xx xx JOB_33 xx xx JOB_99 xx xx JOB_98 xx xx 6 rows selected SQL>所以如果要在plsql窗口里面看到jobs列表,有2种办法:select job,log_user from user_jobs; JOB LOG_USER ---------- ------------------------------
1,在plsql7系列的窗口中执行sql查看: select * from user_scheduler_jobs;