How to start jobs with status not running

From: sjoshi <sjoshi_at_ingr.com>
Date: 29 Jan 2007 20:22:54 -0800
Message-ID: <1170130974.082566.38420@h3g2000cwc.googlegroups.com>

I'm trying to restart jobs with status "NOT RUNNING" but can't seem to.

SQL> select job_name, state from dba_datapump_jobs Where owner_name like 'INGRNET\%';

JOB_NAME                       STATE
------------------------------ ------------------------------
DAO291200721292                NOT RUNNING
DAO29120072132548              NOT RUNNING

SQL> edit
Wrote file afiedt.buf

  1 Declare job_no NUMBER;
  2 BEGIN
  3 job_no := DBMS_DATAPUMP.ATTACH('DAO291200721292');   4 DBMS_DATAPUMP.STOP_JOB(job_no);
  5* END;
SQL> /
Declare job_no NUMBER;
*
ERROR at line 1:
ORA-39002: invalid operation

In worst case, I would like to purge these jobs. Any help is appreciated.

thanks
Sunit Received on Mon Jan 29 2007 - 22:22:54 CST