当前位置: 动力学知识库 > 问答 > 编程问答 >

oracle11g - Cannot select data from DBA_SCHEDULER_JOBS in oracle

问题描述:

I am trying to get the job information (Oracle 11g) by using the following query:

SELECT JOB_NAME, STATE FROM DBA_SCHEDULER_JOBS

WHERE JOB_NAME = 'CHECK_DATES_ON_LOGIN';

but it says "ORA-00942: table or view does not exist".

I am able to describe the table but unable to select from it.

网友答案:

You need DBA privileges to be able to select from that view. If you want to see the jobs the current user owns, use user_scheduler_jobs

SELECT job_name, state 
FROM user_scheduler_jobs
WHERE job_name = 'CHECK_DATES_ON_LOGIN';
分享给朋友:
您可能感兴趣的文章:
随机阅读: