troubleshooting Question

Scheduled Tasks in a 2003 R2 Cluster

Avatar of Lahru
LahruFlag for United States of America asked on
Microsoft SQL ServerWindows Server 2003Microsoft Legacy OS
6 Comments2 Solutions232 ViewsLast Modified:
2 Windows Server 2003 R2 Enterprise Edition in an Active/Passive cluster
Microsoft Cluster Version 5

I've created a series of jobs with the following script:

cluster /cluster:%clustername% res "%Taskname%" /create /group:"Scheduled Tasks" /type:"Volume Shadow Copy Service Task"
cluster /cluster:%clustername% res "%Taskname%" /priv ApplicationName="cmd.exe"
cluster /cluster:%clustername% res "%Taskname%" /priv ApplicationParams="/c %path-to-cmdfile%"
cluster /cluster:%clustername% res "%Taskname%" /priv CurrentDirectory="%WorkingDirectory%"
cluster /cluster:%clustername% res "%Taskname%" /prop Description="%Comments%"
cluster /cluster:%clustername% res "%Taskname%" /prop RestartAction=1
cluster /cluster:%clustername% res "%Taskname%" /Off

I've scrubbed this code by entering %xxx% type variables for purposes of viewing the script without the parameters I actually entered.

The script seems to work fine as far as creating the scheduled task type resource.
The jobs also fail-over successfully between nodes.

The problem seems to be the credentials under which the job executes, the job being a *.CMD script that executes every 5 minutes (purposefully).

If I look at the scheduled tasks folder on each node, the jobs will only appear on the active node.  Now I can open the properties of these tasks in Task Scheduler and set the credentials and the jobs will run.

Doing a failover the jobs disappear from Server1 and appear on Server2, however the credentials revert to NT Authority and the job fails.  I changed the credentials, this time on Server2 and the jobs succeed again.  Fail-over again and the credentials are once again gone.

How can I set these jobs to use specific credentials?
ASKER CERTIFIED SOLUTION
Paul MacDonald
Director, Information Systems

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros