Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Monitor your website or any URL from SQL SERVER Expand / Collapse
Author
Message
Posted Monday, June 22, 2009 6:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 30, 2009 3:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 6:19 AM
Points: 3, Visits: 11
The code is not working -- gives the following error

Msg 102, Level 15, State 1, Line 44
Incorrect syntax near 'end'.
Post #744255
Posted Tuesday, June 30, 2009 9:21 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 22, 2014 9:27 AM
Points: 717, Visits: 689
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
Posted Tuesday, June 30, 2009 9:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 30, 2009 9:22 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 22, 2014 9:27 AM
Points: 717, Visits: 689
Does this process only work if you have dbmail configured? Is there an smtp option?

Dan
Post #744524
Posted Tuesday, June 30, 2009 10:43 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, August 22, 2014 9:27 AM
Points: 717, Visits: 689
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
Posted Tuesday, June 30, 2009 3:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 9, 2010 9:35 PM
Points: 1, Visits: 4
"temporarily"
Post #744894
Posted Wednesday, July 1, 2009 8:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, May 17, 2010 11:16 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 2,017, Visits: 369
thanks :)... i m trying to configure it on my sql server enterprise edition now...
Post #923293
Posted Tuesday, May 18, 2010 1:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 1:47 PM
Points: 123, Visits: 514
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 »

Add to briefcase 12»»

Permissions Expand / Collapse