kgeorge314 / tsqlcron Goto Github PK

Quick links: Summary | Description | Resources

Summary

1. As anyone
2. I want be able to Install tSQLcron
3. so that they can use it in their codebase/project

Description

In order for anyone to use tSQLcron procedures, we need to have a simple, single script install file.

Ideas

1. Use a GitHub Workflow to Concatenate all .SQL files
   • in alphabetical order
   • (or) as per a manifest/build file
2. Deploy the single install script to a blank database
3. Execute all tSQLt test cases

Hi,

First of all, Kudos to you for coming with such solution. Excellent Job.

Second, not sure if this is still being maintained because its very useful.

Third. The issue Im facing is that when I have an interval starting from an hour that is not divisive by the interval , the validation doesnt work as expected. For example: If I set the cron time to be "0 10 7-17/2 * * *" then I expect the following to be valid:

2024-06-20 7:10:00
2024-06-20 9:10:00
2024-06-20 11:10:00
2024-06-20 13:10:00
...
2024-06-20 17:10:00

However its not, and it only work if I use even hours which is not what I expected. If I do the same expression on this site: https://www.freeformatter.com/cron-expression-generator-quartz.html , I get the expected dates:

I know this is not perfect cron but it would be nice if its still work as expected.

Thanks