topic Re: Error with Cron Schedule in Extensions

Error with Cron Schedule

eddbarrientos19 — Tue, 24 Dec 2024 20:02:40 GMT

When attempting to configure a query for the Database Extension 2.0 with a "cron schedule" to run every day at 22:00 (syntax: 0 22 * * * ), I receive the following error:

"Error message: Extension validation error. Constraint violations: $.sqlServer[0].schedule: is not defined in the schema and the schema does not allow additional properties"

Since this is a simple setup, I would like to know why this error occurs and whether this type of scheduling is supported.

Re: Error with Cron Schedule

david_lopes — Tue, 24 Dec 2024 22:04:11 GMT

Replace the last '*' with a '?'. And update your minDynatraceVersion to at least 1.299

The SQL Datasource uses an engine called Quartz Scheduler.

This website: https://www.javainuse.com/cron can be used to test the expressions

NOTE: The SQL Datasource adds an extra zero at the beginning of the string, which are the seconds, so to test your expression add an extra zero on the website.

Example, to use this schedule in Dynatrace: `0 8 ? * 1-5`, validate it with `0 0 8 ? * 1-5` on the website.

The schema documents this as well (either 2nd or 4th index must be a ?)
New cron format release notes: https://github.com/dynatrace-extensions/extensions-schemas/releases/tag/1.299.0

Re: Error with Cron Schedule

Peter_Youssef — Thu, 26 Dec 2024 10:26:23 GMT

Thanks @david_lopes 👨‍💻 for providing applicable solution 😉 .

@eddbarrientos19 You can proceed with an attempt and keep us posted.

Also PFA resources for more info:

Hoping it adds value.

BR,
Peter

Re: Error with Cron Schedule

eddbarrientos19 — Thu, 26 Dec 2024 18:03:39 GMT

Thanks a lot, @david_lopes , for your help and tips! They were super useful for understanding how the expressions work and how to use them. I followed your advice and managed to get the expression working.

@Peter_Youssef , thanks to you too for the extra info—it was really helpful.

I really appreciate both of you. Cheers!

Re: Error with Cron Schedule

Peter_Youssef — Thu, 26 Dec 2024 18:06:34 GMT

Hi @eddbarrientos19
It's our pleasure to contribute together towards reaching applicable solutions.