Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
How to create OEM Scheduled Job and their status report.
I have a requirement to create a report for Top 10 Scheduled jobs and their status on daily basis.
This is not for dbms jobs, this is for We have scheduled all cron jobs like Backup, Purge etc.
Best Answers
-
Hi,
You can use the view MGMT$JOB_EXECUTION_HISTORY to create a report if you mean scheduled in OEM. It not clear to me what you want in the report. And Top 10: could be the number of runs, duration. ...
Eric
-
Yes, i have scheduled the report as daily critical job scheduled report. Using the following query -
MGMT$JOB_EXECUTION_HISTORY
Thanks for the reply.
Answers
-
Hi,
You can use the view MGMT$JOB_EXECUTION_HISTORY to create a report if you mean scheduled in OEM. It not clear to me what you want in the report. And Top 10: could be the number of runs, duration. ...
Eric
-
Yes, i have scheduled the report as daily critical job scheduled report. Using the following query -
MGMT$JOB_EXECUTION_HISTORY
Thanks for the reply.