Currently apoc.periodic.repeat does not handle leader elections.

it runs on the instance where you start it only, and there is no persistent state right now.

There is an open GitHub issue about persisting apoc.periodic.repeat, but we do not have an ETA on when that feature will become available.

In the current state, we recommend using one of the following :

• an external event system
• cron system
• AWS Lambda function
• GCP cloud function

Please also note apoc.periodic.repeat doesn't provide any feedback if the query fails.