Perhaps others have already dealt with this.

 

Is there a way to create a single .cmd file that can be used for one
schedule with multiple sqlservers in a cluster environment so it will
run properly no matter what instance is on any one node or may have
failed to a node it normally does not live on and not report a failure?
Or do I have to make separate schedules for every node each with its own
.cmd file and make sure the .cmd files are on all cluster nodes?

 

 

Geoff Gill 
TSM Administrator 
PeopleSoft Sr. Systems Administrator 
SAIC M/S-G1b 
(858)826-4062 
Email: geoffrey.l.gill AT saic DOT com