I have a PowerShell script do the following tasks:
Loop a big database table Generate text file Zip the text file FTP upload the zipped file Write to the log table
The step generating text file may take short or longer time depends on the data. And the FTP uploading time takes a while. So I want to make at least these two steps asynchronous. Is SQL Server Service Broker a viable choice? Is there any example? Any other options?