Problem in executing and removing DBMS JOB

[Susmitha Metlapalli]

Hi,

I have scheduled a dbms job which runs a procedure everynight at 11:59 PM. I created this on 26-May-2008. It was supposed to run on 26-May-2008 11:50PM. Firstly it did not execute at that time...

Secondly when i tried forcefully to excute the job from TOAD and also from SQL propmt today morning, the TOAD application and the SQL prompt are getting hanged ...

I logged to my schema user which created this job. I am getting my job number when i execute the following query.

select job from user_jobs;

I tried finding whether the job is running using the query

SQL> connect / as sysdba;

SQL>select job from dba_jobs_running;

It is showing my job number.

I am neither able to run the job successfully nor delete it. It is getting hanged.

Please help me in proceeding further.

Thanks & Regards,
Susmitha.

[Susmitha Metlapalli]

Request to help me for the following query posted...

Thanks in advance,
Susmitha Metlapalli.