Thanks for the script. I had a quick play today and the it failed on the first job I tried it on 🙁

It doesn't handle single quotation marks well...

Good article and thank you for taking the time to write and publish it.

As a bit of a sidebar, though, I just go to "Source Control" and grab a...

• This reply was modified 3 years, 9 months ago by  Mikey Bronowski.

Thank you for your input. That would work nicely in non-production environment I guess.

For live systems or those with busy jobs that could be difficult.

I like the discussion here, so...

Mr Pinal Dave to the rescue!

https://blog.sqlauthority.com/2016/06/03/sql-server-maintain-carriage-return-enter-key-ssms-2016-copy-paste/

When we change that setting in SSMS (Query > Query Options... > Grid > Retain CR/LF on copy save )and run the script it...

In the original [comand] all the new lines \ carriage returns, tab exist.

If we change this line in step 3 of the script to replace it with \n, \r and...

Thanks for that. You are right, the script in this form does not handle it well. I have a workaround similar to what you have suggested, but I need to...

This is great - and thanks for sharing!

I did notice that if your job includes any TSQL steps, this will restore the step without any carriage returns. Which may/may...

I have been looking at the code, and I think this could also be used to create rollout scripts for the jobs on new SQL servers from a template...

Wow...

I never thought about using a restore of msdb in this way. ??

I'm going to paste a link to this article in our operations wiki as a "howto"

Thanks for...