How can I schedule a script to run at a certain time of day?  The script

would delete certain records, so should I also somehow block users access

while the script is running?  How can this be done?  Or is there no risk of

transaction conflicts?  Please keep answer simple as I'm a beginner - I've

only heard of transactions - don't know anything about them.



Right now I'm using Access 97, ASP 2.0 and VBScript on PWS on WIN 98.  I

plan to move to a webhost with using IIS 5.0 and SQL Server.



thanks in advance

Well scheduling a script to run is slightly advanced. Both NT and W2K have

the "AT" command. Use the Windows "Help" and search for "schedule"



By advanced I mean, since your script needs to "block" users, then the

script needs to change "file permissions" while it

is running. All of this enters the realm of the Windows Scripting Host

(WSH). WSH is just like VBScript (or Perl,

or whatever scripting language you want to use). You can do alot with VB or

Perl under NT/W2K.



Also, you  can use SQL to schedule tasks to run at system level. Again,

its's not for beginners.



I'd recommed two books on WSH:  Windows Script Host 2.0 Developer's Guide"

(ISBN: 0-7356-0931-4) by Gunter Born

and "Windows Scripting Secrets" (ISNB: 0-7645-4684-8" by Tobias Weltner"



hth,

Dallas Martin



----- Original Message -----

From: "Michael Goldman" <mg188@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, November 23, 2000 4:08 PM

Subject: [asp_databases] maintenance





> How can I schedule a script to run at a certain time of day?  The script

> would delete certain records, so should I also somehow block users access

> while the script is running?  How can this be done?  Or is there no risk



of

> transaction conflicts?  Please keep answer simple as I'm a beginner - I've

> only heard of transactions - don't know anything about them.

>

> Right now I'm using Access 97, ASP 2.0 and VBScript on PWS on WIN 98.  I

> plan to move to a webhost with using IIS 5.0 and SQL Server.

>

> thanks in advance

>

>

> ---

> FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

> IN YOUR INBOX!

> Get the latest and best HTML, XML, and JavaScript tips, tools, and

> developments from the experts.  Sign up for one or more of EarthWeb's

> FREE IT newsletters at http://www.earthweb.com today!




$subst('Email.Unsub')

This is a multi-part message in MIME format.



------=_NextPart_000_0177_01C055FB.0F01C3A0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable





hi,



you create a JOB at the SQL Server



jigs

  ----- Original Message -----

  From: Michael Goldman

  To: ASP Databases

  Sent: Friday, November 24, 2000 2:38 AM

  Subject: [asp_databases] maintenance





  How can I schedule a script to run at a certain time of day?  The 

script

  would delete certain records, so should I also somehow block users 

access

  while the script is running?  How can this be done?  Or is there no 

risk of

  transaction conflicts?  Please keep answer simple as I'm a beginner - 

I've

  only heard of transactions - don't know anything about them.



  Right now I'm using Access 97, ASP 2.0 and VBScript on PWS on WIN 98.  

I

  plan to move to a webhost with using IIS 5.0 and SQL Server.



  thanks in advance





  ---

  FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

  IN YOUR INBOX!

  Get the latest and best HTML, XML, and JavaScript tips, tools, and

  developments from the experts.  Sign up for one or more of EarthWeb's

  FREE IT newsletters at http://www.earthweb.com today! 




$subst('Email.Unsub')