Eric,
If you have nodes that are not replicating, or have not replicated yet,
another approach might be to exclude nodes in RECEIVE or SYNCRECEIVE
instead.
... where node_name in (select node_name from nodes where repl_mode not
like '%RECEIVE') group by node_name
-
Thanks,
Marc...
Marc Lanteign
Hi Lynn,
That is indeed what we are going to do. However, we cannot use the schedule
association because we do not use the SP scheduler. We use a third party
scheduler which is used for all other non-backup related scheduling too.
However, Marc Lanteigne came up with the perfect solution. Thank