Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
How do I check a job submitted thur the Oracle Databse Scheduler to see if it is executing?
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.
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.
Who is Participating?
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.
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.
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)
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)
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?
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?
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.
-
Course of the Month10 days, 2 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
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