What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.
Course Of The Month
8 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How do I check a job submitted thur the Oracle Databse Scheduler to see if it is executing?
Posted on 2007-11-21
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
9 Comments
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
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
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?
Featured Post
Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
This video shows how to Export data from an Oracle database using the Datapump Export Utility. The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility. The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month8 days, 8 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.