Mark Harrison
Reputation: 304434
How do I list jobs in Oracle dbms_scheduler?
How do I list jobs created with Oracle dbms_scheduler.create(...)?
Upvotes: 6
Views: 32316
Answers (1)
Mark Harrison
Reputation: 304434
SELECT owner, job_name, comments FROM dba_scheduler_jobs;
There are many other columns of interest as well.
Upvotes: 14
Related Questions
- Get list of all tables in Oracle?
- Fetch the rows which have the Max value for a column for each distinct value of another column
- How do I limit the number of rows returned by an Oracle query after ordering?
- How do I list all tables in a schema in Oracle SQL?
- Best way to do multi-row insert in Oracle?
- How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
- Oracle: If Table Exists
- How to create id with AUTO_INCREMENT on Oracle?
- What is the difference between Views and Materialized Views in Oracle?