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 3 1855
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Greg D. Moore \(Strider\) |
last post by:
Ok, I thought this one would be easy.
I have a stored proc: master.dbo.restore_database_foo
This is on database server B.
Database server A backs up database foo on a daily basis as a...
|
by: Jason Callas |
last post by:
I have a stored procedure that runs as a step in a scheduled job. For
some reason the job does not seem to finish when ran from the job but
does fine when run from a window in SQL Query.
I know...
|
by: Nasir |
last post by:
Does anyone has a script which gives all databases names and there
allocated, used sizes in SQLserver2k. I want to schedule this to create a
daily report.
Thanks,
Nasir
|
by: A. Lovhaug |
last post by:
I have a console application built in the .NET Framework.
This application basically executes an XCopy based on
parameters that I pass to it. I use it for creating
scripts for backing up folders,...
|
by: John Bowman |
last post by:
Hi,
I have a C# app that needs to launch the "Add Scheduled Tasks" wizard found
in the control panel "Scheduled Tasks" applet. I realize that this "applet"
really just opens the tasks folder,...
|
by: satelite |
last post by:
Hello,
I am writing an exe that is intended to be run via a scheduled task.
However, I also need the flexibility to have users run the scheduled task
manually (right click task and select run). ...
|
by: Mike |
last post by:
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...
|
by: Myster Edd |
last post by:
I have a strange problem that I think deals with security on SQL 2005.
I have a scheduled task that runs on a Windows 2000 machine. It calls
a vb script which creates a connection to SQL Server.
...
|
by: Paulson |
last post by:
Dear Freinds
I want to make a program that acts as a reminder for the
users.I need to open up the Scheduled task wizard programmatically.If you
type Tasks in the run command the Tasks...
|
by: DJRhino |
last post by:
Was curious if anyone else was having this same issue or not....
I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start time is equivalent to 19:00 (7PM) in Central...
|
by: Aliciasmith |
last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
|
by: giovanniandrean |
last post by:
The energy model is structured as follows and uses excel sheets to give input data:
1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
|
by: Teri B |
last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course.
0ne-to-many. One course many roles.
Then I created a report based on the Course form and...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM)
Please note that the UK and Europe revert to winter time on...
|
by: nia12 |
last post by:
Hi there,
I am very new to Access so apologies if any of this is obvious/not clear.
I am creating a data collection tool for health care employees to complete. It consists of a number of...
|
by: isladogs |
last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, Mike...
|
by: GKJR |
last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
| |