SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by SQL SERVER KID / Monitor your website or any URL from SQL SERVER / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:12:57 GMT20RE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxHi 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.Sun, 20 May 2012 23:43:46 GMTsanath.kumar.kuraRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxHi 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 apreciatedTue, 07 Jun 2011 20:09:04 GMTbe.radukRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxI 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.Tue, 18 May 2010 16:54:26 GMTRobert DavisRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxOr you could use a cheap external website monitoring service such as [url=http://www.watchour.com]www.watchour.com[/url]! :-DPersonally, I would leave SQL out of the loop as an application platform and let it do what it does best: manage data.Tue, 18 May 2010 08:38:27 GMTjed-850078RE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxi dont think that the sql server should do this kind of work.although it's good to know, but there are better way's & tools to do it.Tue, 18 May 2010 01:51:36 GMTpelegRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxthanks :)... i m trying to configure it on my sql server enterprise edition now...Mon, 17 May 2010 23:16:57 GMTziangijRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspx[quote] [b] Dan Guzman (6/30/2009) [/b] jobs are under the SQL Server Agent.... I don't know if the SQL server agent is turned on in Express.... [/quote] Dan -- I thought that Sql Agent was required for the sample.That is sad news for Sql Server 2005 Express users because it does not have Sql Agent, according to this link...[url]http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707_mem1,00.html[/url]...where it says this...Other functions not available in Express include clustering or mirroring, full-text indexing or searching, SQLMail, indexed views, partitioned views and SQL Agent. ...so I think I am out of luck.Thank you, regardless.-- Mark KamoskiWed, 01 Jul 2009 08:08:56 GMTkamoskimRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspx"temporarily"Tue, 30 Jun 2009 15:02:03 GMTBruce-1002600RE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxkamoskim,jobs are under the SQL Server Agent.I don't know if the SQL server agent is turned on in Express. I think you have to turn it on at the server the first time. I'm not sureHere is a link that might help:[url=http://msdn.microsoft.com/en-us/library/ms189237(SQL.90).aspx]http://msdn.microsoft.com/en-us/library/ms189237(SQL.90).aspx[/url]Tue, 30 Jun 2009 10:43:44 GMTDan Guzman - Not the MVPRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxDoes this process only work if you have dbmail configured? Is there an smtp option?DanTue, 30 Jun 2009 09:22:48 GMTDan Guzman - Not the MVPRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxDear SQL Server Kid --Please help.I really liked your article...[quote]Monitor your website or any URL from SQL SERVER[/quote]...at this link....[url]http://www.sqlservercentral.com/scripts/monitor+url+from+sql+server/67271/[/url]...but I cannot seem to get it to set up properly.Regarding this...[quote]This code should be added as t-sql step of the job and schedule it[/quote]...how exactly can one create a "job" in SQL Server 2005 Express?Is it possible?I have looked but I see no "Jobs" node in the the Object Explorer in Management Studio Express.Please help.Thank you.-- Mark KamoskiTue, 30 Jun 2009 09:22:01 GMTkamoskimRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxI'm guessing there is an END missing after the second RECONFIGURE at the top, what I would call line 9.I get:Command(s) completed successfullywhen I run it.DanTue, 30 Jun 2009 09:21:11 GMTDan Guzman - Not the MVPRE: Monitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxThe code is not working -- gives the following errorMsg 102, Level 15, State 1, Line 44Incorrect syntax near 'end'.Tue, 30 Jun 2009 03:53:07 GMTer.ankitkhannaMonitor your website or any URL from SQL SERVERhttp://www.sqlservercentral.com/Forums/Topic739322-1574-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/monitor+url+from+sql+server/67271/">Monitor your website or any URL from SQL SERVER</A>[/B]Mon, 22 Jun 2009 06:25:11 GMTkarthik0512