

In the subject you wrote “successful full sys update” but the script and the other suggestions I see so far don’t actually handle the “successful” part.
The log message only tells you that the update was started and the db mtime only indicates that the db was touched without saying anything about success.
I’d go about this by always performing the updates through a wrapper script that could check the exit status of the pacman or yay command and record a timestamp accordingly.
Since you are asking on Lemmy: “provider” or “news server” is like the Lemmy instance and “newsgroup” is like the Lemmy community except it’s a shared namespace across all servers that carry the group so sci.physics is sci.physics everywhere.