Solved

Oralce scheduled jobs

Posted on 2011-03-03
3
358 Views
Last Modified: 2012-06-27
How can I query a oracle 11gR2 database to know the details of a scheduled job -- when it was last run, duration it took to run last, if it was successful or so?
I do not have DBA account and want to see the scheduled job details of my account's jobs only.
0
Comment
Question by:toooki
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 450 total points
ID: 35032628
On mobile and cannot confirm but I think the view you need is;

User_scheduler_jobs
0
 

Author Comment

by:toooki
ID: 35032685
I get error when I run that query.
select * from user_scheduler_jobs error
0
 

Author Comment

by:toooki
ID: 35032753
Ok it could be some IDE tool issue.
It worked on a different IDE.
Thanks a lot!!
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
Do we need servers??? 5 190
Insert with SET how to handle join 6 59
Oracle 10g - insert string with special characters 8 41
SSRS troubles 4 21
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

863 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

23 Experts available now in Live!

Get 1:1 Help Now