The leader said that after oracle was upgraded to 11 GB, it connected to the oracle database, but opened it through plsql. Click the jobs column, and the created jobs list is not displayed, I asked him about his plsql version. He said it was plsql7.1.5.
After google, I came to the conclusion:
The jobs option on the plsql7 series page is to query records in the user_jobs table.
However, the jobs option on the interfaces of Versions later than plsql8 is to query records in the user_scheduler_jobs table;
In practice, jobs in the online oracle Database exist in the user_scheduler_jobs table. I use SQL to query jobs, as shown below:
SQL> select job_name,job_style,job_creator from user_scheduler_jobs;JOB_NAME JOB_STYLE JOB_CREATOR------------------------------ ----------- ------------------------------JOB_23 xx xxJOB_61 xx xxJOB_20 xx xxJOB_33 xx xxJOB_99 xx xxJOB_98 xx xx 6 rows selectedSQL> select job,log_user from user_jobs; JOB LOG_USER---------- ------------------------------
Therefore, if you want to see the jobs list in the plsql window, there are two ways:
1. Execute SQL query in the plsql7 series window: select * from user_scheduler_jobs;
2. Upgrade to plsql8 or a later version, for example, plsql10.2 in the attachment. In the new version, use the jobs option card.