Recurring Jobs

I have a bit of SQL (a single query) that I need to run automatically every few hours. What would be the best way to do that on this host? Are we allowed to schedule server jobs?

I AM using SQL Server 2005.

 

Interesting. I'll have to look into that. Thanks.

 

Hi,
If you created the function but it is not running from the event I'd suspect something is missing or wrong.

As an example of a page load event that runs with no user intervention, this is one I'm using here:

 

Hmmm. I'm stumped on this one. My code is also very simple:

 

That will be a bit tough to pinpoint.
I'd try your event as a function if you can.
As for the DAL, this may help:
http://msdn.microsoft.com/en-us/library/bb426880.aspx

Scroll down to the section on Gracefully Handling DAL-Level Exceptions.
Salute,
Mark

 

I'll give that a shot, thanks. I have some exception management set up and it appears no exceptions are being generated then the page it called, so this will be a tough one.

 

Ok. I've implemented a recurring job but something is still not quite right. What I did was place the method that I need to run inside of the Page_Load event for the page that I have setup through the Recurring Task tool. However, that method never gets called. But, if I navigate to that page myself through my browser it appears the method does get calls and everything functions as it should.

Does the ASP.net page go through the normal lifecycle when an HTTP request is made to that page? I don't see why it wouldn't.

 

i am having the same problem... searching the Form for an answer somewhere else. Please advise.... thanks in advance.

 

Hi,
Which "same" problem...Running a scheduled event?
Salute,
Mark