Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

oracle, databases, 10, checking stored procedure job status

Posted on 2008-06-11
2
Medium Priority
?
447 Views
Last Modified: 2013-12-19
Folks

How and where in Toad can I check if the jobs for the stored procedures are running?

all help will do

Gr

R
0
Comment
Question by:rutgermons
2 Comments
 
LVL 4

Expert Comment

by:Fekrat
ID: 21766179
go to Schema Browser ---> Sched. Job Classes
0
 
LVL 4

Accepted Solution

by:
KICUSek earned 2000 total points
ID: 21767332
dba_jobs_running is very useful view
and
dba_jobs - if columns this_date and this_time are populated then job is currently executing
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

885 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