Could anyone please help to suggest why my refresh policy is not running?

1

Hello

I have created two policies for hourly and daily data
The daily one seems working, but the hourly one seems not working at all.
Thanks in advance for any help!

Hourly policy


select add_continuous_aggregate_policy(
               'hourly_sales_continuous_aggregate_materialized_view',
               start_offset => INTERVAL '1 day',
               end_offset => INTERVAL '1 min',
               schedule_interval => INTERVAL '1 hour'
       );

Daily policy

select add_continuous_aggregate_policy(
               'daily_sales_continuous_aggregate_materialized_view',
               start_offset => INTERVAL '3 days',
               end_offset => INTERVAL '1 min',
               schedule_interval => INTERVAL '1 hour'
       );