Re: MSDE Automatic script at each night
- From: "Norman Yuan" <NotReal@xxxxxxxxxxx>
- Date: Fri, 9 Feb 2007 13:20:53 -0700
If it is MSDE(1.0 or 2000), yes, you can schedule SQL Server Agent to run
jobs, which executes, say, a stored procedure doing the updates you want. If
it is SQL Server Express, no, SQL Server Express does not support Sql Server
Agent.
With MSDE, since it does not have a UI tool (that is, Enterprise Manager),
it is difficult to schedule a job, unless you are very good at using SQL
Server built-in SPs. However, if you have Enterprise Manager, it is very
easy to schedule a job inside MSDE.
If the updating you want is not so complicated, you can also easily write
some VBScript code, using ADO to do the update and use Windows' Scheduled
Tasks" applet to schedule it to run routinely. It can also be used to
schedule osql.exe to execute *.sql script easily.
"Danny" <lane.dj@xxxxxxxxx> wrote in message
news:%23AcI$PITHHA.5108@xxxxxxxxxxxxxxxxxxxxxxx
Can you setup within MSDE a script to be run automatically at 12:01 each
night.... The script is very simple...
such as "UPDATE Item Set SaleType = 0 where SaleEndDate < getdate()" Right
now is run this script vi osql and a schedule batch job.
Is saw something about SQL Server Agent ...
Any help would be appreciated.
Dan
.
- References:
- MSDE Automatic script at each night
- From: Danny
- MSDE Automatic script at each night
- Prev by Date: MSDE Automatic script at each night
- Next by Date: Re: MSDE Automatic script at each night
- Previous by thread: MSDE Automatic script at each night
- Next by thread: Re: MSDE Automatic script at each night
- Index(es):
Relevant Pages
|
