[thelist] Job Scheduling with MS SQL....

Scott Dexter sgd at ti3.com
Thu Apr 6 19:05:44 2000


which version of SQL Server? the DTS stuff in SQL7 is VBScript, not VB, and
you can instantiate objects and all that, gimme a ring offlist....

(we gots lots of that exact solution running round here)

sgd
--
think safely

> -----Original Message-----
> From: Anthony Baratta [mailto:Anthony@Baratta.com]
> 
>   Data is in MS SQL Database
> 
>   I want to schedule a job/service that:
>     - queries the target tables
>     - massages the data retrieved
>     - emails the massaged data to some people
> 
> I would prefer to leverage my ASP knowledge. But its looking 
> like I'll have to learn
> more VB (versus VB Scripting) to do this via the MS SQL 
> Server Agent.