Thanks Kev,
Ok, what I really need to accomplish is something like these scenarios (for
examples):
- I'll need to clean up my DB for an unverified email accounts, say...after
1 month of registering into my system.
- I'll need to clean up my 'log' table that's older than 1 month.
I can create an ASP.NET page and exec SPROC in my backend to accomplish
these things. and exec it at beginning of month. But it won't be automated.
It'll still need me to initiate the action (by exec that ASP.NET page).
I want to do this automatically. So, when a certain 'scheduled-time' (which
I can set it at will) dues, it will executed automatically on server-side.
thanks,
andy
"Kevin Spencer" <uc*@ftc.govwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
There are a number of ways to do this. Which method depends on the type of
operation you want to schedule, which you didn't mention. SQL Server can
run scheduled jobs (various types of jobs, depending on the version).
Windows Task Scheduler can run executables on a schedule. A Windows
Service can run any kind of task on a schedule. An ASP.Net application can
run tasks on a schedule, but is less reliable, as the ASP.Net application
will shut down if it becomes inactive (no client requests) for a
configured interval of time.
--
HTH,
Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist
What You Seek Is What You Get.
"Mike" <ne*********@hotmail.comwrote in message
news:uQ**************@TK2MSFTNGP04.phx.gbl...
Hi all,
In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a
certain operation to be executed, for example, on beginning of a month.
Is there anyway to do this on server-side, either on ASP.NET side or SQL
Server side?
Many thanks in advance,
Mike