Environment: SQL Server 2000 (with SP3a) and Windows Server 2003

If a SQL Agent job is running on the active node when a failover occurs,
what happens to it? Will it restart on the formerly passive node (that then
becomes active)? If yes, will it restart at the same Job step that it was
executing when the failover occurs?

Another scenario: If the SQL Agent job has invoked a .NET Dll registered in
the GAC to perform some tasks when the failover occurs, what happens to that
task? Will the formerly passive node (that then becomes active) restart it
(assuming that the .dll is also registered in the GAC of that node) at the
same Job step that it was executing when the failover occurs?

If a job is running when the cluster fails over, then it is registered as a
failure. If you have the number of retries > 0, then it should attempt to
retry.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"krammai" <krammai (AT) discussions (DOT) microsoft.com> wrote

Environment: SQL Server 2000 (with SP3a) and Windows Server 2003

If a SQL Agent job is running on the active node when a failover occurs,
what happens to it? Will it restart on the formerly passive node (that then
becomes active)? If yes, will it restart at the same Job step that it was
executing when the failover occurs?

Another scenario: If the SQL Agent job has invoked a .NET Dll registered in
the GAC to perform some tasks when the failover occurs, what happens to that
task? Will the formerly passive node (that then becomes active) restart it
(assuming that the .dll is also registered in the GAC of that node) at the
same Job step that it was executing when the failover occurs?