How are Report Schedules held in the database?

Products

• CA Business Service Insight

Issue/Introduction

If I need to confirm the details of a scheduled BSI report, for example to see why one failed or to manually delete a schedule, how are these stored in the BSI database?

Environment

CA Business Service Insight 8.3.x and 9.x

Resolution

The information for a given schedule report is seen in the following BSI database tables:

select * from t_schedules_status where Schedule_Id in (<id list>) ;
select * from t_report_template where report_id in (select report_id from t_report_galleries where Schedule_Id in (<id list>)) ;
select * from t_report_galleries where Schedule_Id in (<id list>) ;
select * from T_Schedules where Schedule_Id in (<id list>) ;

In particular, the t_schedules_status table will show the status of the scheduled report, including the error returned (if there was one) in the schedule_error column. If the report was scheduled correctly, the schedule_error_num column will report 0.