MSDE Automatic script at each night

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


.

Relevant Pages

  • RE: SQL 2000 Upgrade REPLSYS.SQL error
    ... > upgrade again. ... > - Now the setup is failing while executing the replsys.sql script file with ... > - Rerun the setup with the new file. ... > - When it comes to the message.sql script, start SQL from a Command prompt ...
    (microsoft.public.sqlserver.setup)
  • Re: print setup saves the printer
    ... >> is this normal behaviour and do i have to make a setup script for each ... > Setup command by setting the Page Setup to A4 landscape. ... > Using the Page Setup command a script can store the Page ... choose a printer in your operating system's Printer settings ...
    (comp.databases.filemaker)
  • Change local admin settings
    ... At the time, the simplest setup was to make each user a local admin, so ... and cross use PCs as need be. ... the logon script would hopefully add them back in before they'd ...
    (microsoft.public.windows.server.sbs)
  • Re: Remote office users slow logon
    ... Lanwench - My AD is working between sites and it is setup as you ... Les - When I disabled the script entry things were good, ... - 2 minute login times. ... I am running SBS 2003 standard and Server 2003. ...
    (microsoft.public.windows.server.sbs)
  • Re: Need help with running vbs in Custom Actions Commit
    ... You're going to have to post your exact script. ... because that WILL fail in a custom action and is a common error. ... It is extremely ususual for one Dll to require registration before another. ... I am using MSI for my setup project in VS2005. ...
    (microsoft.public.vsnet.setup)