Posted by AlterEgo on 02/06/07 23:07

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" <robboll@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?
>

• Next in forum: Re: Stored Procedure querying another database
• Prev in forum: Re: Stored Procedure querying another database
• Thread view: Re: Who Turned off the SQL Server AGENT???!!!!

[Reply to this message]