Monitor your website or any URL from SQL SERVER

Question

Post reply

Monitor your website or any URL from SQL SERVER

karthik0512

SSC Veteran

Points: 214
More actions
June 22, 2009 at 6:25 am

#210999

Comments posted to this topic are about the item Monitor your website or any URL from SQL SERVER

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

er.ankitkhanna Grasshopper Points: 13 More actions · Answer 1

The code is not working -- gives the following error

Msg 102, Level 15, State 1, Line 44

Incorrect syntax near 'end'.

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 2

I'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 successfully

when I run it.

Dan

kamoskim SSC Enthusiast Points: 185 More actions · Answer 3

Dear SQL Server Kid --

Please help.

I really liked your article...

Monitor your website or any URL from SQL SERVER

...at this link....

http://www.sqlservercentral.com/scripts/monitor+url+from+sql+server/67271/

...but I cannot seem to get it to set up properly.

Regarding this...

This code should be added as t-sql step of the job and schedule it

...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 Kamoski

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 4

Does this process only work if you have dbmail configured? Is there an smtp option?

Dan

Dan Guzman - Not the MVP Hall of Fame Points: 3757 More actions · Answer 5

kamoskim,

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 sure

Here is a link that might help:

http://msdn.microsoft.com/en-us/library/ms189237(SQL.90).aspx

Bruce-1002600 Newbie Points: 5 More actions · Answer 6

Bruce-1002600

Newbie

Points: 5

June 30, 2009 at 3:02 pm

#1017980

"temporarily"

kamoskim SSC Enthusiast Points: 185 More actions · Answer 7

Dan Guzman (6/30/2009) jobs are under the SQL Server Agent.... I don't know if the SQL server agent is turned on in Express....

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...

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707_mem1,00.html

...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 Kamoski

ziangij SSCrazy Eights Points: 8063 More actions · Answer 8

thanks :)... i m trying to configure it on my sql server enterprise edition now...

peleg SSCrazy Points: 2611 More actions · Answer 9

i 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.

jed-850078 Newbie Points: 9 More actions · Answer 10

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

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

Robert Davis One Orange Chip Points: 28027 More actions · Answer 11

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[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]

be.raduk SSC Rookie Points: 25 More actions · Answer 12

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

sanath.kumar.kura Mr or Mrs. 500 Points: 509 More actions · Answer 13

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.

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 14

...how exactly can one create a "job" in SQL Server 2005 Express?
Is it possible?
-- Mark Kamoski

[/quote]

Hi Mark,

One can schedule SQL Server job in Windows Task Schedule using OSQL or SQLCMD. This is an example of the content of the .bat batch file for one of my jobs that sends emails

osql -Sservername -UuserName -PPassword -dDatabaseName -Q"exec DbName.dbo.SPnamel" >"C:\LogName.txt" -n -m-1

One thing that I question is the line for specifying the profile name. While the rest of the scrip works well, sending an email returns an error aabout invalid profile nameas I expected, because the mail server name is not profile name unless the system administrator set up a few profiles with the names same as mail server names.

Yelena

Regards,Yelena Varsha