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 1 of 2

1 2 »»

Monitor your website or any URL from SQL SERVER

Rate Topic

Display Mode

Topic Options

Author

Message

karthik0512

Posted Monday, June 22, 2009 6:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 3:57 AM
Points: 4, Visits: 90

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

Post #739322

er.ankitkhanna

Posted Tuesday, June 30, 2009 3:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 22, 2011 1:22 AM
Points: 3, Visits: 10

The code is not working -- gives the following error

Msg 102, Level 15, State 1, Line 44
Incorrect syntax near 'end'.

Post #744255

Dan Guzman - Not the MVP

Posted Tuesday, June 30, 2009 9:21 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708, Visits: 660

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

Post #744520

kamoskim

Posted Tuesday, June 30, 2009 9:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 12, 2010 8:11 AM
Points: 9, Visits: 12

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

Post #744521

Dan Guzman - Not the MVP

Posted Tuesday, June 30, 2009 9:22 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708, Visits: 660

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

Dan

Post #744524

Dan Guzman - Not the MVP

Posted Tuesday, June 30, 2009 10:43 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708, Visits: 660

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

Post #744648

Bruce-1002600

Posted Tuesday, June 30, 2009 3:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 09, 2010 9:35 PM
Points: 1, Visits: 4

"temporarily"

Post #744894

kamoskim

Posted Wednesday, July 01, 2009 8:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 12, 2010 8:11 AM
Points: 9, Visits: 12

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

Post #745417

ziangij

Posted Monday, May 17, 2010 11:16 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,552, Visits: 359

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

Post #923293

peleg

Posted Tuesday, May 18, 2010 1:51 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:15 AM
Points: 123, Visits: 502

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.

Post #923343

« Prev Topic | Next Topic »

14 posts, Page 1 of 2

1 2 »»

Permissions