Knowledge BaseMetric InsightsMetrics & ReportsData CollectionHow to set up a data collection trigger to start several times a day at a specific time (7:30am, 1:00pm, 5:30pm and 8:00pm)?

How to set up a data collection trigger to start several times a day at a specific time (7:30am, 1:00pm, 5:30pm and 8:00pm)?

Issue:

How to set up a trigger to collect data points at 7:30am, 1:00pm, 5:30pm and 8:00pm every day?

Resolution:

To solve this case create a new Hourly trigger:

and add the Data Dependency for this trigger with the next configuration:

query that is used for Data Dependency:

SELECT IF (
(7 = HOUR(NOW()) AND MINUTE(NOW()) BETWEEN 30 AND 59)
OR
(13 = HOUR(NOW()) AND MINUTE(NOW()) BETWEEN 0 AND 59)
OR
(17 = HOUR(NOW()) AND MINUTE(NOW()) BETWEEN 30 AND 59)
OR
(20 = HOUR(NOW()) AND MINUTE(NOW()) BETWEEN 0 AND 59)

,1, 0) t;
Click to copy

According to trigger run history, it is run in the required periods:

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.