Plsql7 cannot see the jobs list when connecting oracle11G

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.