schedule a job a sql server

I want to create a job to run once a week in sql server agent jobs. Setting up the the job to run is no problem. I want the job to run a sql statement that will retrieve sql. I then want the records to be inserted in a txt file. What is the best way to accomplish this.

The best way to do this is to create a Data Transformation Task and then schedule it as a Job|||I would simply create a step in your job to run some active x code thatwill create a connection to the database, read in the table and exportit to a text file.
HTP
Shane Sukul
|Bsc|Mcsd.Net|Mcsd|Mcad|