Question
June 4, 2007 at 01:13 AM
zsoltfodor

Ignore or eliminate ODBC messages in output of the scheduled SQL Agent job

by zsoltfodor . Updated 19 years, 4 months ago

I have a specified text format output file created in SQL Management studio, it has a corresponding result in it, but after I scheduled it via SQL Agent as a Job, the ODBC?
insert [SQLSTATE 01000] message after every row and ‘statistics’ in teh first row, so it looks like this (a part of the .txt)

Job ‘OLASGL_IF’ : Step 1, ‘OLASGL_IF’ : Began Executing 2007-05-17 14:52:41

1DE200702EUR559000009085463022000008999527463 [SQLSTATE 01000]
2C02010TWO 000000001327942- [SQLSTATE 01000]
2C04081FOU8PWA0000000265200000- [SQLSTATE 01000]
2C04122TWO 000000003435390+ [SQLSTATE 01000]

So how can I eliminate or get rid of these?
Please, Somebody help me! It would be very important because of the dedline of my task!!!!

This discussion is locked

All Comments