RE: Monitor DSN

[Adrian Lynch]

Do a query, wrap in in cftry/cfcatch, in the catch, send an email. So
something...

Ade

-Original Message-
From: John Lucania [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 03:34
To: CF-Talk
Subject: Re: Monitor DSN


Mike,

Can you share your codes with me?

jl

On 11/26/05, Mike Chabot <[EMAIL PROTECTED]> wrote:
> I have a monitor page in each of my applications that is called from
> an external server every five minutes. The monitor page runs a few
> essential queries to test database connectivity. If a query fails, I
> get an E-mail sent from the external server. If the entire page fails,
> I try to call an HTML page in that directory to see if the server is
> up.
>
> You could also buy a product like Whats Up Gold
> <http://www.ipswitch.com/products/whatsup/index.asp> to monitor your
> database server.
>
> -Mike Chabot
>
> On 11/26/05, John Lucania <[EMAIL PROTECTED]> wrote:
> > I often experience that Data Source Names got lost the connectivity
> > due to various reasons such as power outage, reboot, network blip,
> > etc.   Is there a way to monitor the DSN connectivity loss through
> > Scheduled Tasks (sending CFMAIL) or something else?  It is CFMX.
> >
> > jl


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225323
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Monitor DSN

[John Lucania]

Mike,

Can you share your codes with me?

jl

On 11/26/05, Mike Chabot <[EMAIL PROTECTED]> wrote:
> I have a monitor page in each of my applications that is called from
> an external server every five minutes. The monitor page runs a few
> essential queries to test database connectivity. If a query fails, I
> get an E-mail sent from the external server. If the entire page fails,
> I try to call an HTML page in that directory to see if the server is
> up.
>
> You could also buy a product like Whats Up Gold
>  to monitor your
> database server.
>
> -Mike Chabot
>
> On 11/26/05, John Lucania <[EMAIL PROTECTED]> wrote:
> > I often experience that Data Source Names got lost the connectivity
> > due to various reasons such as power outage, reboot, network blip,
> > etc.   Is there a way to monitor the DSN connectivity loss through
> > Scheduled Tasks (sending CFMAIL) or something else?  It is CFMX.
> >
> > jl
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225318
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Monitor DSN

[Mike Chabot]

I have a monitor page in each of my applications that is called from
an external server every five minutes. The monitor page runs a few
essential queries to test database connectivity. If a query fails, I
get an E-mail sent from the external server. If the entire page fails,
I try to call an HTML page in that directory to see if the server is
up.

You could also buy a product like Whats Up Gold
 to monitor your
database server.

-Mike Chabot

On 11/26/05, John Lucania <[EMAIL PROTECTED]> wrote:
> I often experience that Data Source Names got lost the connectivity
> due to various reasons such as power outage, reboot, network blip,
> etc.   Is there a way to monitor the DSN connectivity loss through
> Scheduled Tasks (sending CFMAIL) or something else?  It is CFMX.
>
> jl

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225313
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Monitor DSN

[John Lucania]

I often experience that Data Source Names got lost the connectivity
due to various reasons such as power outage, reboot, network blip,
etc.   Is there a way to monitor the DSN connectivity loss through
Scheduled Tasks (sending CFMAIL) or something else?  It is CFMX.

jl

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225309
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54