Hi

I need guidance to do following excercise.

I have a SP which I need to schedule to run every night and get the output in TXT file. It’s a quite huge file which I need to compress and send by FTP. I believe this whole process can be scheduled in SQL Jobs.

Can anyone suggest correct coding of it?

Thanks for help.

Varsha

Sydney Symphony

Database Analyst