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
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...
February 2, 2021 at 9:59 am
Viewing 9 posts - 1 through 9 (of 9 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy