Solved

How do I check a job submitted thur the Oracle Databse Scheduler to see if it is executing?

Posted on 2007-11-21
9
2,134 Views
Last Modified: 2013-12-19
I have submitted a job thru the Oracle Database using the job scheduler in the database.
It is a job to gather stats.
How do I check to see if this job is actually executing?
I submitted the job using TOAD.
0
Comment
Question by:kzsk31
  • 3
  • 3
9 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
this page is a good cheat-sheet to see the most common information about dbms_job:
http://www.psoug.org/reference/dbms_job.html

1 important note:
* you have to, in toad, after submitting the job, perform a commit, like for a normal table insert.
  otherwise, if you killed toad or closed without committing, the job would be lost.
  and until committed, it will not start
0
 

Author Comment

by:kzsk31
Comment Utility
Hello angellll,
Thank you for sharing this really helpful cheat-sheet for dbms_job.
I did commit the job.
And I still don't know how to check - if a job is running from within the database.

0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
there is a second think you need to know:
the parameter job_queue_processes needs to have a value > 0, otherwise not background job processes will run, and hence not jobs being executed.

once that is set up properly, it should run.

next step, read the data in the dba_jobs:
http://www.ss64.com/orad/DBA_JOBS.html

the column  LAST_DATE will indicate when the job was last started
THIS_DATE being not null means it is currently running, with that date being the start date.
FAILURES , being 0 is good. means no error since last successful execution (if any)

0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:kzsk31
Comment Utility
HI Angelll,
job_queue_processes = 10, so that's good.

SQL> select job, log_user, last_date, last_sec, broken,failures
  2  from dba_jobs;

  JOB LOG_USER   LAST_DATE LAST_SEC                         B   FAILURES
----- ---------- --------- -------------------------------- - ----------
    4 SYS                                                   N

does the above mean that the job is running?  I did execute immediate?
How can I tell what processes/jobs are running on the db?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
this looks like it did not yet run completely.
check out this_date and next_date columns
0
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 250 total points
Comment Utility
select * from dba_jobs_running

will show you jobs that are running right now
0
 

Author Comment

by:kzsk31
Comment Utility
Thanks a lot sdstuber
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Space Delimited Sql File 4 70
Adding a blank row when using union all 4 49
select query - oracle 16 81
Oracle regular expression 6 29
Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now