Timed Database auto maintenance

  • Thread starter Thread starter King Coffee
  • Start date Start date
K

King Coffee

Hi,

I have an ASP.NET database supported website. I want to perform an
automatically generate database update.

Any and all code snippet or reference is greatly appreciated.

Thanks very much,
King Coffee
 
Hi,

I have an ASP.NET database supported website. I want to perform an
automatically generate database update.

Any and all code snippet or reference is greatly appreciated.

Thanks very much,
King Coffee
Click to expand...

Can you please be more specific about your database and what you mean
by "update"? Thanks
 
Thanks Alexey,

I'm thinking of the MySQL .NET database. The period update is to insert new
default info in tables and delete expired table records.

King
 
Hi again,

Basically, I want to run an application level function (a session less
thread) to process an ADO.NET database calls to periodically insert a
default table record and remove expired data. Have any code examples?

King
 
Hi again,

Basically, I want to run an application level function (a session less
thread) to process an ADO.NET database calls to periodically insert a
default table record and remove expired data.  Have any code examples?

King
Click to expand...

Well, it would depend on your server, but you can either use standard
Windows scheduler or write a Windows service to call an application or
a single web page every X minutes. If this is not possible, then you
can look at custom solutions like here: http://www.codeproject.com/KB/aspnet/ASPNETService.aspx
 
Back
Top