Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1920
  • Last Modified:

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.
 
 
0
xoxomos
Asked:
xoxomos
  • 3
  • 2
  • 2
3 Solutions
 
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
 
sdstuberCommented:
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
 
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
sdstuberCommented:
if you don't see it in dba_scheduler_jobs I have no idea where it might be
0
 
konektorCommented:
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
 
konektorCommented:
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now