x

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.

more ▼

asked Sep 20, 2011 at 07:08 AM in Default

avatar image

johnsemi
12 1 1 1

Honestly, I wouldn't use MSX servers. I've found them to be notoriously unreliable. Jobs forget to run, changes don't get pushed out and forget it if you need to retire a server. I know this doesn't solve your problem, just wanted to share the information.

Oct 26, 2012 at 06:23 PM SirSQL

What SQL version was it? That's strange, hasn't been my experience at all (using 2008R2 as MSX if that makes a difference). Been using it for just over a year with no issues, and it's saved me hours and hours of creating/updating jobs.

Oct 26, 2012 at 06:32 PM johnsemi

Every version 2005 and up I've tried it, with little to no success.

Oct 26, 2012 at 08:01 PM SirSQL
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Jun 22, 2012 at 03:11 PM

avatar image

johnsemi
12 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x110
x21
x18
x8

asked: Sep 20, 2011 at 07:08 AM

Seen: 1435 times

Last Updated: Oct 26, 2012 at 08:01 PM

Copyright 2017 Redgate Software. Privacy Policy