Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 out in different xls

Author  Topic 

oracle_corrgi
Yak Posting Veteran

98 Posts

Posted - 2008-01-24 : 00:54:47
hi
i have am osql script (.cmd file) with 80 line query in it
osql -S xxxxxC\C -U uuuuuu -P fefefefe -d proddb  ............ C:\test\monitroing\test.sql -o C:\test\data\1hr_data.xls
, i run every 1 hours once. i shedule in o/s through task manager. i want the output in different xls every time ie: first xls for first hour second xls for second hour ........ till the last hours that is for hours

thanxs


krmm
   

- Advertisement -