Multi-Server Administration - Different schedules for different targets
I've been searching for a solution to this and haven't found ANY information on it (surely I can't be the only one..) Does anyone know a way to create different schedules for a multi-server job that apply only to specific designated target(s)? For example, you would have one generic MSX full backup job- then schedule it for Mondays on TSX A, Tuesdays on TSX B, and so on. I know you can specify certain target servers for multi-server jobs, but I have not found a way to assign schedules based on target.
Maybe I was the only one.. What I ended up doing was using an admin database to manually run jobs. I created a schedules table for all jobs on all instances. Every ten minutes, I run 2 stored procedures. One queries the schedules table, calculates what should run in the next 10 minutes, and puts the jobs into a queue table. The second procedure loops through the queue table, starts each job on the instance specified, and removes the row from the table. The procedures are fairly complex, but the system has worked without fail for almost 9 months now.,Maybe I was the only one