I need to check if my remote network is available every 5 mins. I am thinking to use ping.
exec master..xp_cmdshell 'ping 192.***.**.*'
Base on the output of this query I will know is my network is still available.
How can I save it in the table then determine from there the reply of the ping.
This practice seems not a good practice. Do I have other option?
Any comment is very appreciated.