Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2014-06-25 : 04:58:41
|
| HiWe have a PC set up as an ftp location so we can then drag some files from it and load them into our tables, sometimes this pc gets switched off or loses power and we lose that connection.Is there a way (sql?) to check if the ftp machine is off and if so I can then fire up an e-mail to inform us so we can get it switched back on?I can then set this up in a job and run it periodically to check that all is well.Thanks |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2014-06-25 : 06:11:48
|
| OK, thanks but I've sussed out another way to do this now by putting a dummy file in the directory on the ftp server and checking if this is imported each time the import runs. |
 |
|
|
|
|
|
How to check if an ftp pc is on