?
Solved

oracle, databases, 10, checking stored procedure job status

Posted on 2008-06-11
2
Medium Priority
?
449 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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month8 days, 18 hours left to enroll

621 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