Clustering a scheduled task on Windows Server 2008 R2

Question

I have a two-node cluster running Windows Server 2008 R2. It is essentially an active/passive cluster for SQL Server.

I have set up a scheduled task on the current active node. I want to set up that same task on the passive node but have it so that the task only runs on the active node.

I realise that this version of Windows doesn't support clustered tasks, but I thought that a work-around might be to create another task that is triggered on the node becoming 'active' which enables the first task, and a partner task to disable the first task when the node becomes 'passive'.

I haven't found anything on the internet about doing something like this though, so I was wondering whether this was possible, and if so how?

Seyf Seyf · Accepted Answer · 2016-04-08T12:00:50

I use generic script for enabling and disabling tasks:

WshShell = new ActiveXObject("WScript.Shell");
strEnableTask = "schtasks /change /ENABLE /TN \"\\Task\"";
strDisableTask = "schtasks /change /DISABLE /TN \"\\Task\"";

function Open() {
 return true;
}

function Online() {
 oExec = WshShell.Run(strEnableBackup, 0, true);
 return oExec.ExitCode;
}

function LooksAlive() {
 return true;
}

function IsAlive() {
 return true;
}

function Offline() {
 oExec = WshShell.Run(strDisableBackup, 0, true);
 return oExec.ExitCode;
}

function Close() {
 return true;
}

function Terminate() {
 return true;
}

Clustering a scheduled task on Windows Server 2008 R2

2 Answers