Help - Search - Members - Calendar
Full Version: 10g2 jobs via sqlplus
Oracle DBA Forums > Oracle > Oracle Forum
richard102
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
burleson
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.