Viewing 9 posts - 1 through 9 (of 9 total)
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...
February 4, 2021 at 12:27 pm
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...
February 3, 2021 at 7:02 am
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...
February 2, 2021 at 5:51 pm
Mr Pinal Dave to the rescue!
When we change that setting in SSMS (Query > Query Options... > Grid > Retain CR/LF on copy save )and run the script it...
February 2, 2021 at 4:39 pm
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...
February 2, 2021 at 4:23 pm
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...
February 2, 2021 at 3:04 pm
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...
February 2, 2021 at 2:08 pm
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...
February 2, 2021 at 11:24 am
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"
February 2, 2021 at 9:59 am