Viewing 15 posts - 9,466 through 9,480 (of 9,725 total)
Except for the problem that the job is what actually schedules the SSIS package, so using SSIS to schedule the job wouldn't work except in a very recursive, clumsy way.
A...
September 5, 2007 at 8:44 am
The more I think about your idea, Ed, the more I like it. I'm not sure how easy or hard it really would be for MS to code it up,...
September 5, 2007 at 8:34 am
I definitely would like to just go in and click a little check box next to each job step to say "Disabled". It would make my life much easier. And...
September 5, 2007 at 7:11 am
As much as I hate to suggested it, the only way you can do what you want is through the use of dynamic SQL. Stored procedures and Cursors don't like...
September 5, 2007 at 6:01 am
Well, the agent does support that sort of thing much in the same manner as John mentioned the disabling of steps. What you do is use the sp_start_job proc to...
September 5, 2007 at 5:35 am
Okay, now I feel just plain silly. @=)
I completely forgot about that functionality... Thanks for reminding me, John.
September 4, 2007 at 11:34 am
Half the stuff posted on Monster anymore seems to be trying to get people into Sales jobs or get them into training classes. It's sad.
Worse when they stick ads for...
August 29, 2007 at 10:22 am
Good point on the definition, Matt.
I actually meant outsourced in the sense that the DBA A) a contractor (not employed directly by the company and B) doesn't come into the...
August 28, 2007 at 8:36 am
I'm glad my forgetfulness could help someone out. @=)
August 28, 2007 at 7:49 am
If the practice tests are any example, I'm thinking you have 145 minutes total for the exam. The other stuff may be covered by NDAs (I haven't taken the test...
August 28, 2007 at 3:58 am
Has anyone noticed whether DBAs get outsourced? I've heard of programming, help desks and other call centers getting outsourced, but I've never heard one instance of DBA outsourcing.
I can't imagine how anyone could...
August 28, 2007 at 3:56 am
HA! I'm not going crazy!!!
I just found the errata for this book on Microsoft's Website. No wonder I'm frustrated. There are a LOT of typos in this stupid book.
Moral of...
August 27, 2007 at 6:57 am
AHA! I think I finally found the the way to turn XML datatype data into data you can operate on.
Does the Nodes() method sound correct to anyone?
August 24, 2007 at 12:37 pm
Seems to me that they were definitely more worried about the education problem, though.
And people think schools in Florida are bad! @=)
August 24, 2007 at 10:41 am
I find it extremely amusing that U.S. companies are starting to go elsewhere because of rising salaries and labor shortages. What did they think was going to happen once everyone...
August 24, 2007 at 9:38 am
Viewing 15 posts - 9,466 through 9,480 (of 9,725 total)