Automating Query Analyzer

[JDTurk]

Using Query Analyzer, I’ve written a query that produces an import file of employee data that is sent (via FileZilla) to a company we’ve hired that tracks employee benefits. My question is how would I go about automating this system? I’m new to this so it’s hard for me to visualize exactly how this could happen.

S8730 Processors (Redundncy/Mirror Img)
Aura 5.2 (Communication Manager)
Modular Messaging 5.2

 

[SQLBill]

You would create a job to run the script. You don't say which version of SQL Server you are using, but it shouldn't make a difference.

In SSMS, expand SQL Server Agent, then right click on Jobs. Select New Job and set it up to run your script. Depending on the length of the script, you could just put it into a job step. But a 'best practice' is to turn the script into a stored procedure and call the stored procedure from the job step.

Refer to the BOL (Books OnLine) that come with the SQL Server installation for more details.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875