[thelist] Automatic Refresh [SOLVED]

Ken Schaefer Ken at adOpenStatic.com
Tue Mar 28 05:46:53 CST 2006


I don't even understand why WinHTTP is needed. Why can't you create a job
that is run by the SQL Agent? That's what SQL Agent is for - running
scheduled tasks. Have the Agent run a job at 5:00am (or whatever) to clear
out, and populate your temporary table.

Cheers
Ken

: -----Original Message-----
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Rob Smith
: Subject: Re: [thelist] Automatic Refresh [SOLVED]
: 
: 
: > Talk about a gnarly solution.  It would be much better to set up a
: > task within SQL Job Agent that calls a small job that does nothing
: > other than instantiate a WinHTTP request to the page you are
: > currently using as your homepage.
: 
: :-D I'm still laughing about your comment. Here I was jumping up and
: down thinking I've solved a month long problem only to have someone say
: "Bah. Newbie"
: 
: I'm trying to find the documentation on How and What the WinHTTP T-SQL
: statement is and looks like...   :-\
: 
: Rob Smith




More information about the thelist mailing list