osql or isql

Guys:
Im new in MS SQL and I have little experienco on IBM DB2. I want to run a simple select query on a table, but I want to do it automatically... What do you recommend?? Where I can get information about OSQL or ISQL usage??'
Best regards,What do you mean 'automatically'? You can create stored procedure and run it from Quiry Analyzer by name. You can define parameters for selection criteria. Go to Online Help or Transact SQL help in Query Analyzer.|||for example in Unix you have the cron option. Means that I create the *.sql script and I schedulle it to run at certain time|||You can use SQL Server Agent.

Good luck.|||Go to Job Scheduling in Tools, Enterprise Manager. Use Create Job Wizard. Good luck.|||by the way, the query I use is very simple, select * from MEMBERS where MEM_ENTERED between '2002-05-06 00:00:00' and '2002-05-06 23:59:59'

I need to use change the date everyday. It is posible or exist the value = current date / current time in MS SQL to avoid changind date/ time everyday..

Regards|||Try this:
SELECT * from MEMBERS
where convert(char(10),mem_entered, 101)
= convert(char(10),getdate(),101)

You retrieve all the records entered for the day.

Good luck|||Thanks It works.
Just one question more. With that query I can get data for the current date. How I could change it to get for the previous day ??

In IBM DB2 I just made the date variable equal to current date - 1 day.
I will appreciate it|||Use getdate()-1 instead of getdate()- current date|||Thanks !!
It works. I will put it as schedulled job.|||I schedulled the job. But How I see the results?? Does it sends it to a log file??|||jeremas, is your goal is to run a sql script based on a cron job and dump the results to a text file?|||Thanks. I already found the way to run the query, schedule it and sending the results to a txt file. It was using the SQL Server Agent and job scheduling and properties.

Regards,