Adding a resource (Generic Script) to the SQL Cluster

I would like to add a VB Script to the SQL Cluster so that
in the event of a failover the script will execute on the
new active node. The script goes out and checks for the
existance of some key files once a day.
I am running Windows 2003 SQL 2000 in an Active / Passive
configuration.
I have the VBS running every morning through task Mgr, but
I would like to get it configured to run as a clustered
resource and failover to the active node.
Thanks,
In 2003, there is a "Generic Script" resource type that support VBS and Perl
scripts. Check out the following for more details:
http://msdn.microsoft.com/library/de...ric_script.asp
Regards,
John
"Rodney" <anonymous@.discussions.microsoft.com> wrote in message
news:441301c47333$a3be4aa0$a601280a@.phx.gbl...
> I would like to add a VB Script to the SQL Cluster so that
> in the event of a failover the script will execute on the
> new active node. The script goes out and checks for the
> existance of some key files once a day.
> I am running Windows 2003 SQL 2000 in an Active / Passive
> configuration.
> I have the VBS running every morning through task Mgr, but
> I would like to get it configured to run as a clustered
> resource and failover to the active node.
> Thanks,

add event to application log

How do I add events to be recorded in the application log? I have a process
that is not completing 100% of the time, but I am not getting any events
recorded in the application log. The severity must be < 20. I realize that
opeing this up to all events will cause a lot of activity, but I need to fin
d
out why this process does not complete every time it is run.
Thanks in advance.Doug,
Check out:
sp_addmessage
RAISERROR ... WITH LOG
xp_logevent
The choice will depend on your approach.
HTH
Jerry
"doug" <doug@.discussions.microsoft.com> wrote in message
news:310BB4E6-F9B4-4907-948A-7715B3289C04@.microsoft.com...
> How do I add events to be recorded in the application log? I have a
> process
> that is not completing 100% of the time, but I am not getting any events
> recorded in the application log. The severity must be < 20. I realize
> that
> opeing this up to all events will cause a lot of activity, but I need to
> find
> out why this process does not complete every time it is run.
> Thanks in advance.

add event to application log

How do I add events to be recorded in the application log? I have a process
that is not completing 100% of the time, but I am not getting any events
recorded in the application log. The severity must be < 20. I realize that
opeing this up to all events will cause a lot of activity, but I need to find
out why this process does not complete every time it is run.
Thanks in advance.Doug,
Check out:
sp_addmessage
RAISERROR ... WITH LOG
xp_logevent
The choice will depend on your approach.
HTH
Jerry
"doug" <doug@.discussions.microsoft.com> wrote in message
news:310BB4E6-F9B4-4907-948A-7715B3289C04@.microsoft.com...
> How do I add events to be recorded in the application log? I have a
> process
> that is not completing 100% of the time, but I am not getting any events
> recorded in the application log. The severity must be < 20. I realize
> that
> opeing this up to all events will cause a lot of activity, but I need to
> find
> out why this process does not complete every time it is run.
> Thanks in advance.