March 18, 2010 at 6:19 pm
I have a scenario where we are running 2 databases under a single Sql Server 2008 instance. My quandary is that we have a deployment situation where we have the same named scheduled jobs that have unique parameters for each of the above mentioned databases. Is there a way to create a second copy of the msdb (of course named differently like msdb_1 and msdb_2) in the same Sql Server instance and point it to their respective databases?
March 18, 2010 at 6:41 pm
The sql agent is programmed to look at the msdb database. I don't think there is any way around the situation. You will need to rename the dup jobs - or add additional steps to the jobs to permit the execution of different params.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 7:07 pm
Thanks Jason!!!
This is a good thing to understand ... back to my DBA with more info under my belt!
March 18, 2010 at 8:02 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply