Stop scheduled jobs from running

When i look at JOBS in OEM:
 

View  ExecutionsRuns
 Create Job  CloneHomeHost CommandPatchRMAN ScriptRefreshFromMetalinkSQL Script
 
                 
 
 
Select Name Status (Executions) Scheduled Targets Target Type Owner Job Type
 BACKUP_BB60.CCC.EDU_000115 1 Scheduled Oct 17, 2007 2:00:00 AM GMT-07:00 BB60.ccc.edu Database Instance SYS Database Backup
 BACKUP_BB60.CSCC.EDU_000116 1 Succeeded Oct 16, 2007 1:16:16 PM GMT-07:00 BB60.ccc.edu Database Instance SYS Database Backup

I see a job named  BACKUP_BB60.CCC.EDU_000115 scheduled for 2am tomorrow.

I try running:

SQL> select job_name from dba_scheduler_jobs;
and return:

JOB_NAME
------------------------------
PURGE_LOG
FGR$AUTOPURGE_JOB
GATHER_STATS_JOB
AUTO_SPACE_ADVISOR_JOB
ADV_SEGMENTADV_7390631

What table do i find the  BACKUP_BB60.CCC.EDU_000115 1 in?
This is the job i want to stop scheduling to run every morning.
 
 
xoxomosAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
oops
DBA_SCHEDULER_PROGRAMS  not DBA_SCHEDULE_PROGRAMS

to see the rest of the SCHEDULER views you can look them up with this...


SELECT view_name
  FROM dba_views
 WHERE owner = 'SYS' AND view_name LIKE 'DBA_SCHEDULER%'
0
 
sdstuberCommented:
DBA_SCHEDULER_JOBS  to find the jobs

if the job itself is an action then look in job_action

if the job is a collection of actions look in program_name

then look up DBA_SCHEDULE_PROGRAMS to find the pieces of that program
0
 
xoxomosAuthor Commented:
Still not seeing it.  OK, if from OEM i go to maintenance ->schedule backup,--> through the steps to submitt,
where do i look to get information about that backup i just scheduled?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
sdstuberCommented:
if you don't see it in dba_scheduler_jobs I have no idea where it might be
0
 
konektorConnect With a Mentor Commented:
is your job planned using dbms_scheduler?
it might be planned using dbms_jobs - then you find it in dba_jobs view
or it might be run from os using os sheduler. uinx: crontab -l
0
 
konektorConnect With a Mentor Commented:
run select * from v$session when it actually run to find information about who fires it
0
 
xoxomosAuthor Commented:
No, i just open up Enterprise Manager Database Control,
Maintenance
Schedule Backup
I get a job name, but querying those views is not showing it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.