Need some work done? Post a Project Today
I need a script that will pull a list of SQL server names from a csv, then take that list and check to see if the "Write to Windows Application event log:" is set. If it is set it will write the details of how it is set (when the job fails, when the job succeeds, when the job completes) to another file. If it is not set, it will set it to a state of "when the job fails".
Prefer a TSQL, or a Powershell script to take care of this. Will also consider VBS.