Video Screencast Help

Needs a Only Successful main Job Reports

Created: 25 Nov 2013 | 5 comments
emret's picture


I am new on opscenter queries. I need a report displays only the successful backup job reports last 24 hours. does the anyone have this query ?

Operating Systems:

Comments 5 CommentsJump to latest comment

Will Restore's picture

an easy way is to use existing template and modify it, like this

Report Templates > Backup > Job Browser > Tabular Backup Report

Edit Report > Filters > Job > Job Status = Successful 

Add > Run Report

Will Restore -- where there is a Will there is a way

emret's picture

Hi wr, thanks for the answer. but is that report show the all successful backup include main & child job. l just need to only main kob results.

emret's picture

Hi inn_kam,

thanks for the link. l am able to create customer query but i did not find the how to create only successful main job. when l generate the report l get whole successful backup result and for example my only one oracle backup job has more than 150 stream and in the report l saw all stream result but l need the just a main job result.

watsons's picture

Probably it's better to use "Advanced report" for that, in this type of report, you can choose the "Metric type" to be Job which will display only the parent/main job,  choose Stream if you want to see every job streams (child jobs).

Related technote: