Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

Oralce scheduled jobs

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
toooki
Asked:
toooki
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
On mobile and cannot confirm but I think the view you need is;

User_scheduler_jobs
0
 
toookiAuthor Commented:
I get error when I run that query.
select * from user_scheduler_jobs error
0
 
toookiAuthor Commented:
Ok it could be some IDE tool issue.
It worked on a different IDE.
Thanks a lot!!
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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now