Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SQL Server Job Steps Expand / Collapse
Author
Message
Posted Wednesday, March 23, 2011 10:33 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:06 AM
Points: 1,786, Visits: 1,113
Comments posted to this topic are about the item SQL Server Job Steps
Post #1083081
Posted Wednesday, March 23, 2011 10:33 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Thanks for the question!
Post #1083082
Posted Thursday, March 24, 2011 1:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:26 AM
Points: 13,622, Visits: 10,509
A bit easy, but still 40% (at the moment) got it wrong



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1083111
Posted Thursday, March 24, 2011 2:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:52 PM
Points: 2,270, Visits: 3,789
Thanks for the question. Easy one.

Mohammed Moinudheen
Post #1083125
Posted Thursday, March 24, 2011 2:28 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:16 AM
Points: 484, Visits: 812
They got it wrong because they are using 2005 & the question doesn't specify the version and I suspect most businesses are still using 2005 for production systems.
Post #1083133
Posted Thursday, March 24, 2011 2:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:20 PM
Points: 5,975, Visits: 8,236
A good question. It would have been a great question if the author had not forgotten to specify the version - Powershell is not supported in SQL Server 2005, so that might cause some incorrect replies.

It was a nice touch to indicate the number of answers that has to be checked. Though this makes it easier as well - since there were only five options, I knew I had the correct answer as soon as I identified the one incorrect option. Would it not have been simpler to ask us to check the option that is NOT a job step and require only a single answer?

I hope to see more questions from this contributor.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1083138
Posted Thursday, March 24, 2011 2:57 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:55 AM
Points: 558, Visits: 1,475
Good question and not too difficult. I did my certs in 2008 and so my natural inclination was to answer the question with that version in mind
Post #1083142
Posted Thursday, March 24, 2011 3:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
Hugo Kornelis (3/24/2011)
A good question. It would have been a great question if the author had not forgotten to specify the version - Powershell is not supported in SQL Server 2005, so that might cause some incorrect replies.

It was a nice touch to indicate the number of answers that has to be checked. Though this makes it easier as well - since there were only five options, I knew I had the correct answer as soon as I identified the one incorrect option. Would it not have been simpler to ask us to check the option that is NOT a job step and require only a single answer?

I hope to see more questions from this contributor.

Ah, that explains it. If it didn't say "Select Four," I would have gotten the question wrong because I frequently create Steps in Jobs have never seen "Powershell" or "Reporting Services Report Subscriptions" options so I would have only selected 3. I use 2005 and had to look this one up before answering to find the proper 4th option.
Post #1083152
Posted Thursday, March 24, 2011 5:36 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 11:26 AM
Points: 668, Visits: 485
Nice and easy one..Thanks for the question.
Post #1083202
Posted Thursday, March 24, 2011 6:27 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:01 PM
Points: 687, Visits: 3,002
As others have pointed out, the "correct" answer is wrong. Powershell is NOT an option in 2005. I got it right for the wrong reason: I guessed that Powershell integration was more likely in in 2008 than an RS subscription.

These kinds of versioning problems with QoD are common enough and easily prevented: couldn't SSC require all submitters to specify which versions they have tested their question on?

Rich

Post #1083221
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse