Select to find which backup stg pool admin sched failed and error for failure

[sandratechie27]

Select to find why backup storage pool failed and the error for failure

Hello,

Does anyone know a select statement that will tell us which backup storage admin schedule has failed for the last 10 days and the errror for the failures I used this select statement but it does not provide the anr error for failure. Does anyone know what are we missing?

select date(start_time) as "Start Date",time(start_time) as "Start Time",date(end_time) as "End Date",time(end_time) as "End Time",number as "Process #",activity,schedule_name,entity,bytes,successful from summary where schedule_name='ADMIN_SCHED_NAME'

Thanks
​

 

[cfhoffmann]

If you fix the typo in 'successful' it will run, but since there are no ANR errors listed in the summary table it will never give you the result you want.
Try running a query on the ACTLOG table instead and check the MESSAGE field.

 

[sandratechie27]

Yes, but will like to know specific select statement to generate the list of errors for failures on the backup stg pool.

Thanks for the hint