ORA-12012: error

ORA-12012: error on auto execute of job 719358



 select  d.job_name,d.job_action  from  dba_scheduler_jobs d,sys.scheduler$_job s where d.job_action = s.program_action and s.obj# = &myjobnum;

enter no 719358

select job, what from dba_jobs where broken = 'Y' or failures > 0; for broken jobs




provide following grant to the user and then try to execute the job.

'Grant select any table to user_name'

SQL> execute dbms_job.run(444);
BEGIN dbms_job.run(444); END;

*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 406
ORA-06512: at "SYS.DBMS_JOB", line 272
ORA-06512: at line 1

Elapsed: 00:00:09.82

SQL> Grant select any table to username;

Grant Succeeded.

Elapsed: 00:00:01.30

SQL> execute dbms_job.run(444);

PL/SQL procedure successfully completed.

Elapsed: 00:00:08.30