June 22, 2009 at 6:25 am
Comments posted to this topic are about the item Monitor your website or any URL from SQL SERVER
June 30, 2009 at 3:53 am
The code is not working -- gives the following error
Msg 102, Level 15, State 1, Line 44
Incorrect syntax near 'end'.
June 30, 2009 at 9:21 am
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
June 30, 2009 at 9:22 am
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
June 30, 2009 at 9:22 am
Does this process only work if you have dbmail configured? Is there an smtp option?
Dan
June 30, 2009 at 10:43 am
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
June 30, 2009 at 3:02 pm
"temporarily"
July 1, 2009 at 8:08 am
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
May 17, 2010 at 11:16 pm
thanks :)... i m trying to configure it on my sql server enterprise edition now...
May 18, 2010 at 1:51 am
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.
May 18, 2010 at 8:38 am
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.
May 18, 2010 at 4:54 pm
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.
June 7, 2011 at 8:09 pm
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
May 20, 2012 at 11:43 pm
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.
August 19, 2013 at 3:34 pm
...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
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply