Add doc for scheduled trigger

What does this MR do? merged into master and will happen in 9.1. This MR is for the documentation.

Are there points in the code the reviewer needs to double check?

Why was this MR needed?

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

What are the relevant issue numbers?

Closes #30440 (closed)