Disabled Schedules

Question

Post reply

Disabled Schedules

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
July 2, 2017 at 12:10 am

#77597

Comments posted to this topic are about the item Disabled Schedules

Viewing 12 posts - 1 through 11 (of 11 total)

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

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Nice easy one to start the week thanks Steve, perhaps a little close to the previous one though?

...

Robin Wilson SSCertifiable Points: 5014 More actions · Answer 2

Oh got it wrong but good question!

Is it odd that it says the QOTD was posted on 08/06/2017?
Should it now have today's date?

Robin

Mighty SSCrazy Eights Points: 9063 More actions · Answer 3

Tiny comment about the explanation. It is not true that nothing can trigger the job: you can trigger the job manually.

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 4

Nice, easy question to start the week on, thanks Steve

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

morlindk SSCrazy Points: 2294 More actions · Answer 5

A most unsurprising answer. Two options were effectively identical - so both had to be wrong. Another one sounded somewhat far-fetched. So, only the simplest - and correct - option remained.

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 6

Today's question is strikingly similar to the 6/27/2017 question.
The good news is the the percentage of correct answers on today's question is higher than on the 6/27 question. We're learning! <Smile>

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

robinwilson - Sunday, July 2, 2017 12:26 PM
Oh got it wrong but good question!
Is it odd that it says the QOTD was posted on 08/06/2017?
Should it now have today's date?
Robin

You've mis-translated the date. This is June 8, 2017.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 8

Mighty - Monday, July 3, 2017 1:27 AM
Tiny comment about the explanation. It is not true that nothing can trigger the job: you can trigger the job manually.

That's not a trigger, IMHO. That's a manual start.

Stewart "Arturius" Campbell SSC Guru Points: 72625 More actions · Answer 9

Steve Jones - SSC Editor - Monday, July 3, 2017 8:23 AM
Mighty - Monday, July 3, 2017 1:27 AM
Tiny comment about the explanation. It is not true that nothing can trigger the job: you can trigger the job manually.
That's not a trigger, IMHO. That's a manual start.

we can go on into a copious amount of detail about everything that can start a job, irrespective of the job's own schedule, e.g. another job or a stored procedure or a process on another server, to name but a few.
However, that is not what this question is asking.
This question can (and should) be answered correctly by anyone with some DBA experience.

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

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Steve Jones - SSC Editor - Monday, July 3, 2017 8:23 AM
Mighty - Monday, July 3, 2017 1:27 AM
Tiny comment about the explanation. It is not true that nothing can trigger the job: you can trigger the job manually.
That's not a trigger, IMHO. That's a manual start.

I agree that a manual start isn't a trigger.

But the explanation is still a bit inaccurate, since a trigger can call sp_start_job. I have used that in error management, so it's not something obscure that no-one ever does. Although getting developers and dbas to do error management with automatic containment in order to avoid having recover from a disaster can be rather difficult, there are quite a few of us who believe it's better to do error containment so as not to have a disaster to recover from wherever possible - but of course as it's not always possible we still have to plan for disaster revovery and test the disaster recovery process regularly).

Tom

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

Stewart "Arturius" Campbell - Monday, July 3, 2017 8:32 AM
Steve Jones - SSC Editor - Monday, July 3, 2017 8:23 AM
Mighty - Monday, July 3, 2017 1:27 AM
Tiny comment about the explanation. It is not true that nothing can trigger the job: you can trigger the job manually.
That's not a trigger, IMHO. That's a manual start.
we can go on into a copious amount of detail about everything that can start a job, irrespective of the job's own schedule, e.g. another job or a stored procedure or a process on another server, to name but a few.
However, that is not what this question is asking.
This question can (and should) be answered correctly by anyone with some DBA experience.

Agreed. It seemed like a simple one.

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