We are setting up multiple SQL Virtual Machines, spread over multiple nodes, so that they can auto migrate between nodes for load balancing, or for automatic failover during troubling times. These VMs use Hyper V.
Each time one of these VMs boot, a Scheduled Task is run to do some prerequisite checks before allowing the SQL Service to start. If the prerequisite checks fail, the database instance will not start.
Question is, is it possible for the same scheduled task to start when a VM is migrated? We need the same checks to take place when the VM arrives at a different node. Are scheduled tasks cluster aware? Is a migration treated the same as a newly booted server?