Once we’ve let a few hours pass, there should be several invocations of the step we scheduled to run hourly. Then we can show the invocations for the step in our schedule object:

1 SQL> select id, object_name, state, status, created_instant, completed_instant from (show invocations) where object_name = ‘s_run_insert’ order by completed_instant;

After a day, we should have 23 or 24 invocations. Let’s check the target table we created:

1 SQL> select * from delta.schedule_example order by inserted_at;

We can see that our job is running every hour.