Monitor your website or any URL from SQL SERVER

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by SQL SERVER KID » Monitor your website or any URL from SQL...

14 posts, Page 2 of 2

««1 2

Monitor your website or any URL from SQL SERVER

Rate Topic

Display Mode

Topic Options

Author

Message

jed-850078

Posted Tuesday, May 18, 2010 8:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 08, 2011 7:03 AM
Points: 1, Visits: 7

Or you could use a cheap external website monitoring service such as www.watchour.com! BigGrin

Personally, I would leave SQL out of the loop as an application platform and let it do what it does best: manage data.

Post #923634

Robert Davis

Posted Tuesday, May 18, 2010 4:54 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 1,560, Visits: 1,408

I agree with peleg about it not being an appropriate job for SQL Server. Beyond that, it is an interesting use of the OLE Automation procedures.

One recommendation, I would suggest checking the current state of the OLE automation config setting and only enabling/disabling it if it wasn't already enabled. If it is enabled for a reason, such as required by an application, then you could break functionality of whatever uses it.

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #923979

be.raduk

Posted Tuesday, June 07, 2011 8:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 17, 2013 6:19 PM
Points: 3, Visits: 163

Hi Guys,

Im looking at adding a simple job to monitor an internal website and its external site. Ive set up the job and its running fine, Only thing is its always raising the alert.

Ive changed the url to "google" and get the same results, Have I missed something or has anyone had this issue?

Help would be much apreciated

Post #1121485

sanath.kumar.kura

Posted Sunday, May 20, 2012 11:43 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 22, 2013 12:13 AM
Points: 19, Visits: 128

Hi SQL Guru's,

Can i use this code where i can login into website with credentials and check the latency.

if latency is beyond the thresshold then it need to fire the email and pager too.

is that possible..

if possible then help me to get the code.

Thank you.

Post #1303181

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions