but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy, we'd just run: ...

Next you need a batch script to execute the ftp commands ... To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general ...