July 2, 2017 at 12:10 am
Comments posted to this topic are about the item Disabled Schedules
July 2, 2017 at 12:11 am
Nice easy one to start the week thanks Steve, perhaps a little close to the previous one though?
...
July 2, 2017 at 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
July 3, 2017 at 1:27 am
Tiny comment about the explanation. It is not true that nothing can trigger the job: you can trigger the job manually.
July 3, 2017 at 1:35 am
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”
July 3, 2017 at 1:48 am
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.
July 3, 2017 at 7:45 am
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>
July 3, 2017 at 8:22 am
robinwilson - Sunday, July 2, 2017 12:26 PMOh 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.
July 3, 2017 at 8:23 am
Mighty - Monday, July 3, 2017 1:27 AMTiny 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.
July 3, 2017 at 8:32 am
Steve Jones - SSC Editor - Monday, July 3, 2017 8:23 AMMighty - Monday, July 3, 2017 1:27 AMTiny 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”
July 4, 2017 at 3:49 am
Steve Jones - SSC Editor - Monday, July 3, 2017 8:23 AMMighty - Monday, July 3, 2017 1:27 AMTiny 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
July 5, 2017 at 6:51 pm
Stewart "Arturius" Campbell - Monday, July 3, 2017 8:32 AMSteve Jones - SSC Editor - Monday, July 3, 2017 8:23 AMMighty - Monday, July 3, 2017 1:27 AMTiny 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.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
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