I'm in a little bind.
I have a MS SQL database that does nightly backups and creates a file every night that needs to be backed up.
I need to find a way to test that a backup file was created within the last 24 hours and if it hasn't, to write to the Windows Logs so that an agent can alert me that there's been an issue.
I do not want to only rely on MS Sql Studio to let me know of failure but I want a Windows way to record this for redundancy.
All the monitoring software that I've found will keep track of changes but I don't know of any that will test a directory for a file and only trigger when the file is not there.
I'm thinking powershell but I don't know the language or even if it's able to do it.
Any suggestions (or a sample script) will be greatly appreciated.