Home > IT Answers > Microsoft Windows > OUTPUT query
D197212
5 pts.
 OUTPUT query
OSQL, SQL
hi i have am osql script (.cmd file) with 80 line query in it [code]osql -S xxxxxCC -U uuuuuu -P fefefefe -d proddb ............ C:testmonitroingtest.sql -o C:testdata1hr_data.xls[/code], 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

Software/Hardware used:
ASKED: January 24, 2008  6:13 AM
UPDATED: January 24, 2008  2:11 PM
RELATED QUESTIONS
Answer Wiki:
DTS or SSIS would be a more appropriate tool for this task then osql is.
Last Wiki Answer Submitted:  January 24, 2008  7:19 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.