戻る
-
タイトル
Where can I find a history of scheduled reports running (or failing to run)? -
説明
Customer may request a history of scheduled reports, successful or failed. -
対策
Currently, there is no in-program module to give this information.
A SQL query can be run to get the last status of a scheduled report task. However, each time the report runs, that status gets overwritten, not a new record created.
SQL file attached or use below code:
SQL Code:
Use dbReporterSelect tblScheduleObject.ScheduleObjectName, tblScheduleObject.Status, tblScheduleObjectErrors.MessageId, tblScheduleObjectErrors.ParameterFROM tblScheduleObjectINNER JOIN tblScheduleObjectErrors ON tblScheduleObject.ScheduleObjectId = tblScheduleObjectErrors.ScheduleObjectIdAn enhancement request has been entered for this feature.
-
Defect ID
TF00191562 -
添付ファイル