SQL Job Agent History format

  • Is there any way to fix the formatting? I'm just getting lines of text without carriage return/line feeds. It makes it very difficult to read. I know I can log to a file, but it'd be nice to be able to view it without having to map a drive and dig for the log.

  • Not that I know of 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I do not think you can affect the way the "Log Viewer" displays the data but if you log the output to a table it will retain the line breaks. On the Job Step properties, Advanced Page, check "Log to Table" and your job output will be written to msdb.dbo.sysjobstepslogs. Be careful though. If you generate a ton of output from your jobs using this table can bloat msdb in a hurry. Just make sure you maintain the job history and indexes on a regular basis.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply