I am building a Data monitoring system to catch data issues on prod DB. I have written some SQL scripts with all validation and the script returns data which fails the validations.
- Is there any free to tool to do this or is there a better way to achieve this?
- How can I schedule my SQL scripts to run on regular intervals from one of our servers?