Powershell, Task Scheduler or loop and sleep
- by Paddy Carroll
I have a job that needs to go off every minute or so,
it loads a DLL i have written in C# that retrieves state for an SQL Server Mirror (Primary, Mirror and witness) for a number of databases;
it allows us to poke DNS to show where the primary instances are. Please don't mention Clustering - We're not doing that.
I can't be arsed to write a…