peacesells (7/16/2013)
george sibbald (7/16/2013)
each node with two instances gives you 4 instances, and that is very much active\active, or as I believe Microsoft would officially call it, a multi-instance cluster.You will have to put the jobs into the msdb relevant to the database the job is for, so just log onto the correct database engine and create the job via SQLAgent for that instance, using the virtual SQL name.
The link I posted shows you how to manage multi instances, its just a case of adding new xml nodes for each msdb and\or file system if you are using the file system to store the packages. NAme them so you can readily identify which is which when you open SSIs via management studio.
George,
Clearly i am not a cluster aware guy- but nonetheless very interesting subject if you can figure your way through.
don't worry, you're not the only one
I read somewhere that sql server agent was cluster aware which interprets to me that it if i need a job running in one of the instances on both nodes- will it suffice to create a job in one of the instances of the job using the virtual name and should that node fail the job is also visible on the same instance on the other node.
correct
For instance I have nodeA with (instanceD,InstanceF) ANd NodeB with (instanceD,InstanceF). Now i only need a sql server agent job running on InstanceD on both nodes. My understanding is that i don't have to create the job on both nodes for those two instances-please correct me.
correct, you only need to create the job once on the virtual instance
Since i am doing a file system deployment (my package would reside in shared disk), i do not see my packages in MSDB-should i be worried?
nope, that would be expected, you would have to physically import the package into msdb (via SSIS) to se it in msdb.
msdb is usually the better place to store packages, but its not a golden rule, you may want to investigate why the file system has been chosen.
You have a 2 instance cluster which is currently active\passive only because both instances are live on the same node. It is perfectly possible for just one instance to failover in which case you would then be active\active. So reaally its clearer to call it muti-instance.
[/quote]
---------------------------------------------------------------------