Formatting Job Step Commands

When I create a script for a SQL Agent job I like to format the job step command with tab's and line-feeds using CHAR(9) and CHAR(13) respectively within a string of SQL.  This then gives me a nicely formatted string when you view the job through EM.

If I view the same job through 2005 Management Studio the step commands that were so nicely formatted  in 2000 EM are now just one long line, wiht no formatting.

Is there a way that I can format the step command string as I creat the job through my SQL script




Answer this question

Formatting Job Step Commands

  • Formatting Job Step Commands