Scheduled exec

[Mike]

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

[Kevin Spencer]

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

[Mike]

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

[Kevin Spencer]

DB tasks can be done in SQL Server via Jobs.

As for your "log" table, if it's in SQL Server, this can be done by creating
a Job as well.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.
"Mike" <ne*********@hotmail.comwrote in message
news:ul**************@TK2MSFTNGP03.phx.gbl...

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