You are here: Re: Who Turned off the SQL Server AGENT???!!!! « MsSQL Server « IT news, forums, messages
Re: Who Turned off the SQL Server AGENT???!!!!

Posted by robboll on 02/08/07 13:10

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация