Schedule a System Activity report that sends when other scheduled reports fail

[LookerExperts]

Knowledge Drop

Last tested: Nov 7, 2020
 

Using System Activity you can tell if a scheduled report was successfully sent. Schedule this System Activity explore as an hourly report, by adding the Advanced Send this schedule if there are results and you'll be notified if another schedule failed.

https://[HOSTNAME]/explore/system__activity/scheduled_plan?fields=scheduled_job.created_date,scheduled_job.status_detail,scheduled_job.status,dashboard.title,look.title,scheduled_plan_destination.address&f[scheduled_plan.run_once]=No&f[scheduled_job.created_date]=1+days&f[scheduled_job.status]=failure&sorts=scheduled_job.status_detail&limit=500&column_limit=50&query_timezone=America%2FLos_Angeles&vis=%7B%22hidden_fields%22%3A%5B%22scheduled_job.status%22%5D%7D&filter_config=%7B%22scheduled_plan.run_once%22%3A%5B%7B%22type%22%3A%22is%22%2C%22values%22%3A%5B%7B%22constant%22%3A%22No%22%7D%5D%2C%22id%22%3A0%2C%22error%22%3Afalse%7D%5D%2C%22scheduled_job.created_date%22%3A%5B%7B%22type%22%3A%22past%22%2C%22values%22%3A%5B%7B%22constant%22%3A%221%22%2C%22unit%22%3A%22day%22%7D%2C%7B%7D%5D%2C%22id%22%3A3%2C%22error%22%3Afalse%7D%5D%2C%22scheduled_job.status%22%3A%5B%7B%22type%22%3A%22%3D%22%2C%22values%22%3A%5B%7B%22constant%22%3A%22failure%22%7D%2C%7B%7D%5D%2C%22id%22%3A4%2C%22error%22%3Afalse%7D%5D%7D&dynamic_fields=%5B%5D&origin=share-expanded

This content is subject to limited support.