Project Not Rescanning - SQL Fix

Problem

When the "Date of last scan" for a project is further in the past than the rescan period,
then the project will not automatically rescan.
In this situation, manual rescans will still work, but not automatic/scheduled scans.

Solution

In this situation, to re-enable automatic rescans, we need to correct the "last scanned at" date.

An SQL query to fix this is as follows:

UPDATE [config].[t_Project]
SET [LastScannedAt] = SELECT convert(DATETIME, convert(DATE, getdate() ) )
WHERE [RescanPeriod] IS NOT NULL

Explanation:

For any project which has a rescan period,
Update the time the project was rescanned to exactly midnight this morning. – Casting the results of getdate() to a date then back to a datetime throws away the hours/minutes/seconds of the current date.

Related articles