In SSMS perform the following queries on the Change Auditor database to reset the Last Run dates:
NOTE: It is always recommended to backup your SQL database or affected tables when running any queries on the Change Auditor database.
1. This query will remove the erroneous run history:
DELETE FROM Query.ReportHistory
WHERE LastRun > GETDATE()
2. This query will reset the Last Run date on the Report History in the client to Never, allowing to resume the report processing.
UPDATE Query.ReportMail
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center