Very Computer

by **Dianna Brade** » Wed, 14 Nov 2001 01:50:46

How can I get the output from SQl job to not be binary? I have on numerous
occasions needing to get info out of various job output files, but am very
limited how I can do it - other then opening it up in Notepad and searching
manual for what I need - painful.

Thanks for any help.
Dianna

by **Mike** » Wed, 14 Nov 2001 08:27:00

Quote:> How can I get the output from SQl job to not be binary? I have on
> numerous occasions needing to get info out of various job output files,
> but am very limited how I can do it - other then opening it up in
> Notepad and searching manual for what I need - painful.

My job logs are .txt files in ASCII text. Are you sure you are not talking
about the "report" that you can ask for? That is, I believe, in crystal
report format which is why it appears binary to you.

--
Mike Harms
SQL Server MVP

by **Dianna Brade** » Wed, 28 Nov 2001 21:54:59

Yes, I can pull the output up in Notepad - but it has binary characters in it - which doesn't allow for me to do stuff with it externally.

Does your output have little binary square characters?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

by **Mike** » Sat, 01 Dec 2001 02:13:54

Quote:
> Yes, I can pull the output up in Notepad - but it has binary characters
> in it - which doesn't allow for me to do stuff with it externally.

> Does your output have little binary square characters?

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

I believe that is because it is outputing a crystal report format. Crystal
Reports comes with Back Office to allow you to read those.

--
Mike Harms
SQL Server MVP

Very Computer

Sql job out is binary

Sql job out is binary

Sql job out is binary

Sql job out is binary

Sql job out is binary