Can you please help. I want to run a query at midnight everyday. The query is a simple one and it goes like 'SELECT * FROM table_name' and save the output to a file in unix directory. Currently iam able to save the output to a file from a command line with this statement
#isql -SGBOMC1 -Ppasswd -Uusername -ofile
select * from table_name
Now I want to put this in a crontab so that it runs every midnight and I am having difficulty doing that and will appriciate any help.