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 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
do I
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?