• One can always use a System Startup Procedure to find the node failover, instead of having the job run every 5-10 mins.

    Please read this how it can be done: http://msdn.microsoft.com/en-us/library/ms191129.aspx