where can i find not-truncated job history comments?

[stiej]

Hi,

sometimes when i read the job history, i rarely find an entry that isn't truncated - how can i find the full message, it always tends to truncate just where the most useful piece of information is.

thanks.

 

[SQLBill]

What do you mean by truncated? Are you right clicking on the job, selecting View Job History, and then clicking the check box for Show Step Details?

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

It will always truncate when it's inserted into the table as the field only allows for 1024 characters. If you want the full output you'll need to use the option within the job step to write the output to a file on the disk.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[stiej]

Ahhh thank you both. yes, it was the step details. and yes, good idea - write the output to a file. thanks guys!