Hello again

I've an issue with Oracle 10g2 on a Solaris Cluster. I need to alter some jobs for an application upgrade without the benefit of OEM.

First part is removing some old 'deprecated' jobs (I have their names), trouble is, cannot find them ... DBA_JOBS shows about 4 jobs, ALL_JOBS shows no jobs at all !!
(nb: I'm logging into solaris/sqlplus as 'oracle', and sqldeveloper as sys).

Should I just concentrate on fixing EM ?

tks
richard101

Hi Ricgard,

>> I need to alter some jobs for an application upgrade without the benefit of OEM.

That's good, the command line interface is far better.


**********************************************************************
>> First part is removing some old 'deprecated' jobs (I have their names), trouble is, cannot find them ...

You need to check the dba_scheduler view, like dba_scheduler_jobs.

http://www.dba-oracle.com/job_scheduling/d...eduler_jobs.htm

If you don't already have it, get the book "Oracle Job Scheduling":

http://www.rampant-books.com/book_2005_1_scheduling.htm