Tuesday, March 27, 2012

FTP related

Hi All,
I have an FTP Server where the users are sending files (say the server
name is fs1). I was wondering whether there was a way to know every two
hours that the FTP server was up writing sql codes (SQL server is
running on a different server and the server name is dbs1). If it is
down (for any reasons) then I want to send mail to network personnel. I
want to put that code in a scheduled job to run every two hours.
Could any one please help what I can do in this situation?
Thanks a million in advance.
best regards,
mamunConsider using MOM for this:
http://www.microsoft.com/mom/default.mspx
David Portas
SQL Server MVP
--

No comments:

Post a Comment