Forum Discussion
Mike_Moniz
3 months agoProfessor
LM has a that "SQL System Jobs" check that can report if an existing job fails, but don't think it has one for if a job is missing all together or check if it Integrity was done in other ways. Checking the Exchange I don't see one there that sounds like it matches your needs, except for "Custom SQL Queries (Write Custom SQL Queries that will output a single number)" which might work if you are able to write a SQL statement that returns something like number-of-days-since-last-integrity-check. I don't know mssql well enough if that exists.
Otherwise you might have to write your own DataSource. Perhaps based on the SQL System Jobs one.
Related Content
- 3 months ago
- 2 months ago