Solved

oracle, databases, 10, checking stored procedure job status

Posted on 2008-06-11
2
437 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Database Upgrade 13 62
Oracle - Create Procedure with Paramater 16 56
grouping on time windows 6 42
SQL query question 8 36
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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.

910 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

18 Experts available now in Live!

Get 1:1 Help Now