Posted by robboll on 02/09/07 22:32

On Feb 8, 12:30 pm, "AlterEgo" <altereg...@dslextreme.com> wrote:
> robboll,
>
> Sorry, I forgot about the Messenging Service.
>
> Most of the scripts I use I found on the Internet. I don't script often
> enough to remember the object models, so I just search for them. This one I
> just happened to have used several years ago to solve a common problem.
> Novice DBAs and other operators see the "Start service when OS starts"
> checkbox as checked and sometimes think that Agent starts when you start SQL
> Server. They forget that starting SQL Server does *not* automatically start
> the SQL Server Agent, which is always stopped if you stop SQL Server.
>
> These links might be a good start for you:
>
> http://msdn2.microsoft.com/en-us/library/ms950396.aspxhttp://www.microsoft.com/technet/scriptcenter/learnit.mspx#EXBhttp://www.microsoft.com/technet/scriptcenter/guide/sas_roa_overview....
>
> -- Bill
>
> "robboll" <robb...@hotmail.com> wrote in message
>
> news:1170940248.791749.71630@v33g2000cwv.googlegroups.com...
>
>
>
> > On Feb 6, 5:07 pm, "AlterEgo" <altereg...@dslextreme.com> wrote:
> >> robboll,
>
> >> Yes, Task Scheduler. You are running VB Script not VB, which should be
> >> available on your server by default. Save the script file with a VBS (not
> >> BAS) extention.
>
> >> -- Bill
>
> >> "robboll" <robb...@hotmail.com> wrote in message
>
> >>news:1170800482.966971.157190@v33g2000cwv.googlegroups.com...
>
> >> >> > Is there a simple way of letting the Database Administrator know
> >> >> > when
> >> >> > the SQL Agent get turned off? I know this can happen from time to
> >> >> > time, but I need a mechanism to shoot me an email or something when
> >> >> > this happens. I know -- I can set up a SQL Agent job to do that ;)
>
> >> >> > Any suggestions greatly appreciated!!!
>
> >> >> > RBollinger- Hide quoted text -
>
> >> >> - Show quoted text -
>
> >> > Do you mean Task Scheduler on the server? Doesn't there need to be an
> >> > application that runs VB on the server?- Hide quoted text -
>
> >> - Show quoted text -
>
> > Are you the author of this little jewel? It works like a champ.
> > Can you recommend a good reference for this kind of VB scripting?
> > Something tells me that you can use VB scripting for just about
> > anything that requires maintenance and monitoring -- rather than
> > expensive utilities that have more features than you need.
>
> > One thing that had me stymied for awhile -- For Messaging to work, the
> > Messaging Service must be running on the server and the clients.
> > Messaging is turned off by default on Windows XP and Windows Server
> > 2003.
>
> > Thanks again,
> > RBollinger- Hide quoted text -
>
> - Show quoted text -

Thanks -- I'll check them out! Have you tried this with SQL Server
2005?

[Back to original message]