Thanks, that seems like a simple and clean way to go.  I'll try it.

I'm a newbie, and this is my first app.  Fortunately (or unfortunately,
depending on how you look at it), I'm the client, business owner, and chief
janitor, so I get to clean up any mess left by this little app.  I wish I'd
read about n-tier before starting this project, but at this point, it's way
too far along to apply those principles.  I'll keep them in mind as I write
the first major revision, or for my next app.


----- Original Message -----
From: "Xu Gary" <Gary.Xu@p...>
To: "Security_asp" <security_asp@p...>
Sent: Friday, January 26, 2001 2:19 PM
Subject: RE: alternatives to WSH?


> I don't what exactly is "cleansing". If it is to clean data, I would say
it
> should be done at SQL using SP. And of course SP can be scheduled inside
SQL
> using SQL Agent.
>
>
>
>
> -----Original Message-----
> From: Martin Lacey [mailto:lacey@f...]
> Sent: Friday, January 26, 2001 10:27 AM
> To: Security_asp
> Subject: RE: alternatives to WSH?
>
>
> Alternatively, and applying a more strict n-tier distributed component
> architecture and proper isolation of the data services layer from the
> business layer...
>
> I would suggest creating a COM component that encapsulates the DB Access
and
> cleansing algorithms, and calling this components from your ASP in IIS.
> Also, I would stray away from embedding the logic in a stored procedure as
> this contrasts from the OO encapsulation of functionality and spreads it
> between the business object layer (your new COM object) and the Data
> Services layer (your Database or actual COM components providing access
> services).
>
> Martin.
>
>
> -----Original Message-----
> From: Xu Gary [mailto:Gary.Xu@p...]
> Sent: Friday, January 26, 2001 9:37 AM
> To: Security_asp
> Subject: RE: alternatives to WSH?
>
>
> Yes, you should write a stored procedure to do the job. This SP can be
> scheduled and also can be called from anywhere including IIS.
>
>
>
>
> -----Original Message-----
> From: nigel.barker@s... [mailto:nigel.barker@s...]
> Sent: Friday, January 26, 2001 2:51 AM
> To: Security_asp
> Subject: RE: alternatives to WSH?
>
>
> Agreed - All data cleansing exercises should be done from within the DBMS
> where possible - If you are using SQL server you will be able to run
activex
> scripts from the scheduler etc should you need to interact with an
external
> object.
>
> Cheers
>
> Ledge
>
> -----Original Message-----
> From: Maciek Siedlaczek [mailto:maciek@s...]
> Sent: 26 January 2001 19:26
> To: Security_asp
> Subject: RE: alternatives to WSH?
>
>
> Hi! I think, You should to use DB agent to run scheduled job which
contains
> stored procedure.
> Maciek
>
>
> Hi,  A webhost told me they consider WSH a security risk for shared
hosting.
> True?
>
> I want to schedule script to run every night to look at my db, and if
> certain criteria are met, delete certain records.  Presently, I have a
> vbscript in a web page that I can run manually to do this task.
> Alternatives?
>
> Thanks in advance,
>
> Mike
>
>