Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to check my job name from the database...

960032Sep 5 2012 — edited Sep 5 2012
I have written one job scheduler which is as follows :
SQL> ED
Wrote file afiedt.buf

1 DECLARE
2 X NUMBER;
3 JobNumber NUMBER;
4 BEGIN
5 SYS.DBMS_JOB.SUBMIT
6 (
7 job => X
8 ,what => 'scott.SPLITSMS;'
9 ,next_date => SYSDATE+1/1440
10 ,interval => 'SYSDATE+1/1440 '
11 ,no_parse => FALSE
12 );
13 JobNumber := to_char(X);
14* END;
15 /

PL/SQL procedure successfully completed.


Now I want to check whether the job has been really created or not?

so for that I have used the following command line:

SQL> SELECT JOB_NAME FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'SCOTT.SPLITSMS';
SELECT JOB_NAME FROM DBA_SCHEDULER_JOBS WHERE JOB_NAME = 'SCOTT.SPLITSMS'
*
ERROR at line 1:
ORA-00942: table or view does not exist

how to check my job name from the database...

what is the command used to check the job_name ????

and how can i ensure that my job scheduler is running properly...???

please help ........my dear friends.....!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 3 2012
Added on Sep 5 2012
7 comments
6,477 views