July 9, 2010 at 9:23 am
I can no longer view the job history log for a scheduled job. Instead of showing the history, the log file viewer summary section is blank and indicates the error 'string or binary data would be truncated' in the lower left hand section of the viewer (the progress section).
I believe it is related to the output message being long. The job happens to run a SP that backs up 4 databases and the output message is long. If I only backup 1 database, the job history shows. In order to see the history of that 1 database backup, I need to delete/recrate the job - to clear out the log.
Useing SQL version: 10.50.1600.1 (x64) standard
July 9, 2010 at 9:45 am
The issue can be resolved by modifying the msdb system SP:
sp_help_jobhistory_full
by limiting the length of the field message to left(message,1024) - (there are two places it is selected)
However, it seems like this should be addressed by Microsoft.
July 10, 2010 at 1:38 am
What version of SSMS are you using? I know this happens if you use SSMS2005 to view job history on SQL Server 2008.
July 12, 2010 at 6:19 am
Yes, I am using 2005 SSMS going to SQL2008.
Thank you for pointing that out.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply