You can also use SQLDMO object...

Harshang

--- "Kim, Cardyin" <CKim@s...> wrote:
> SQL Server has it's own scheduler called SQL Server
> Agent.
> You may want to look into this instead instead of
> reinventing
> the wheel.
> 
> Cardyin
> 
> -----------------------------------------
> Cardyin Kim
> Client/Server and Web Development Analyst
> San Antonio Community Hospital
> Upland, California
> ckim@s...        (xxx) xxx-xxxx
> -----------------------------------------
> 
> 
> -----Original Message-----
> From: sstewart [mailto:sstewart_59102@y...]
> Sent: Tuesday, February 19, 2002 1:52 PM
> To: professional vb
> Subject: [pro_vb] Creating a vb scheduler
> 
> 
> I have a SQL Server 7 database with stored
> procedures that I want to run 
> on a set schedule.  I am using a vb front end and
> want to create an 
> interface for the SQL Server scheduler.  What
> references do I need to set 
> to access the SQL Server scheduler?  Is there any
> other pertinant 
> information I need to know?
> 
> sstewart
> $subst('Email.Unsub')...
> 
$subst('Email.Unsub').


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com