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
5  1151 
Use SQL Agent and Jobs. ASP.Net has nothing to do with this approach.
--
JS
BRE Bank Dev Team, Poland
Uzytkownik "Mike" <ne*********@hotmail.comnapisal w wiadomosci news:ua**************@TK2MSFTNGP03.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
SQL Server has a job scheduler. You can also setup a Windows scheduled task on the server
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"Mike" <ne*********@hotmail.comwrote in message news:ua**************@TK2MSFTNGP03.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 Jacek,
How to do this, as I'm new to this. Can you please provide a sample script or further reference for this?
thanks,
andy
"Jacek Stawicki" <js*****@gazeta.plwrote in message news:e9**********@inews.gazeta.pl...
Use SQL Agent and Jobs. ASP.Net has nothing to do with this approach.
--
JS
BRE Bank Dev Team, Poland
Uzytkownik "Mike" <ne*********@hotmail.comnapisal w wiadomosci news:ua**************@TK2MSFTNGP03.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
Hi Eli,
I don't think I can use a Windows sched task job, because I'll run it on a shared-server (with a hosting).
thanks,
andy
"Eliyahu Goldin" <re*************@monarchmed.comwrote in message news:%2****************@TK2MSFTNGP04.phx.gbl...
SQL Server has a job scheduler. You can also setup a Windows scheduled task on the server
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"Mike" <ne*********@hotmail.comwrote in message news:ua**************@TK2MSFTNGP03.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
Then they might not let use their SQL Server job scheduler either. Ask your host.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"Mike" <ne*********@hotmail.comwrote in message news:ev**************@TK2MSFTNGP02.phx.gbl...
Hi Eli,
I don't think I can use a Windows sched task job, because I'll run it on a shared-server (with a hosting).
thanks,
andy
"Eliyahu Goldin" <re*************@monarchmed.comwrote in message news:%2****************@TK2MSFTNGP04.phx.gbl...
SQL Server has a job scheduler. You can also setup a Windows scheduled task on the server
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
"Mike" <ne*********@hotmail.comwrote in message news:ua**************@TK2MSFTNGP03.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: jdaelhousen |
last post by:
I have a bit of a problem I'm hoping someone can shed some light on...
I have a VB.Net console application written in VS 2003 that produces a .exe file that now sits on a Windows 2000 server...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
