September 22, 2009 at 9:56 pm
A job has been created in nodeA.
fail over the cluster to nodeB.
will the job run in nodeB?
September 22, 2009 at 10:39 pm
September 23, 2009 at 1:35 am
The Job should run in node B.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
September 23, 2009 at 1:42 am
Sumanta-1056020 (9/23/2009)
The Job should run in node B.
Should is the object word, you dont know what the job does or its dependencies
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 23, 2009 at 2:52 am
Like Elliott W replied the job will not be automatically resubmitted because of a failover;
However, if the job has an active schedule or is being activated by any other means, it will be launched accordingly.
Will the job be able to run successfully ? Maybe. :ermm:
If it refers to local file addresses, that are not part of the cluster group, you will have to pre-allocate them and provide the necessary authorization for the sqlagent service account or proxy of the job.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply