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 service, there simply isn't enough time
- Task Scheduler - every minute: Invoke a powershell script that loads the DLL does the business
- Task scheduler - At Startup : Invoke a similer powershell script that loads the DLL once but then loops and sleeps, refreshing the Object that the DLL exposes.
Pros and cons?