Disabled Schedules

Question

Disabled Schedules

Steve Jones - SSC Editor

SSC Guru

Points: 736140
More actions
June 26, 2017 at 10:52 pm

#77596

Comments posted to this topic are about the item Disabled Schedules

Viewing 7 posts - 1 through 6 (of 6 total)

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

Stewart "Arturius" Campbell SSC Guru Points: 72622 More actions · Answer 1

Nice, easy question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Darko Martinović Hall of Fame Points: 3545 More actions · Answer 2

Thanks Steve for this question!
As non-native speaker, I found the title of this question is a little bit confusing 🙂.
The topic is about how is disabled job behaviors.
So, maybe instead of 'Disabled Schedules', better title would be 'Disabled Job'
or something like that 🙂

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

That was an easy one. I admit I had to read it again looking for the trick.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

George Vobr SSCrazy Eights Points: 9994 More actions · Answer 4

Thanks for this interesting question Steve. I learned a lot from this, especially when I found this old post on the SSC forum and even this request on MS Connect .
Very much depends on the way how you disable a job, see the argument @new_name in sp_update_job (Transact-SQL).

webrunner SSC-Dedicated Points: 31858 More actions · Answer 5

Thanks for the instructive question!
- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Revenant SSC-Forever Points: 42467 More actions · Answer 6

Hi, Steve! Thanks for yet another interesting question.