Rick Schummer <> wrote: > Stephen, > >>> But you can write that as a developer as part of your app.<< > > Sure you can work around the missing SQL Server Agent, but it sure is > nice to have it built in and accessible without the need for me to > write something myself. It works great and is reliable. I believe > several developers are surprised by this. I know I was when I heard > about it in Jim Duffy's session at Advisor Devon.
Scheduler is a 50/50 success in my years of NT/Win2000/Win2003 experience. The tie into a "user" and their pw, and pws change and no notice comes back that the darned schedule didn't run. The time it takes to find it's loaded in the scheduler of that server is what chafes my butt! > Also, I do not have to worry about the user killing a task out of the > Windows Task Scheduler, and it is one more thing to worry about when > deploying a vertical market application, and even a custom app. I > know the user can shut down SQL Server Agent, but when the job does > not complete successfully I can have it email me. Now it just does > not run. A poor design decision by Microsoft in my opinion. I agree! Agent was a good thing, and the tracking with it was good. Last run successfully column always gave the heads up! Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.17/505 - Release Date: 10/27/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
