I have a scheduled stored procedure running in parallel on two machines one being the failover
in SSMS 2014.

The FTP happens first using DOS and then 15 minutes later the scheduled stored procedure (SP) runs.

How can I tell using SQL, SSMS, etc. which server is the "ACTIVE" on since my failover kicked in during those 15minutes and the SP ran twice on both boxes within milliseconds

Any ideas or suggestion or references really appreciated

TIA

George