470,815 Members | 1,261 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

Scheduled exec

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

Jul 23 '06 #1
3 1742
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
Jul 23 '06 #2
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


Jul 23 '06 #3
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



Jul 23 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jason Callas | last post: by
5 posts views Thread by A. Lovhaug | last post: by
6 posts views Thread by John Bowman | last post: by
1 post views Thread by satelite | last post: by
5 posts views Thread by Mike | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.