|
|
Posted by AlterEgo on 02/08/07 18:30
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.aspx
http://www.microsoft.com/technet/scriptcenter/learnit.mspx#EXB
http://www.microsoft.com/technet/scriptcenter/guide/sas_roa_overview.mspx?mfr=true
-- Bill
"robboll" <robboll@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
>
>
>
>
>
[Back to original message]
|