Need Dirxn --> How to schedule recurring stored procedure executio

From: Richard (Richard_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 15:15:05 -0800

Hi,

I need to schedule a stored procedure to run on a recurring basis. It would
be acceptable if the procedure ran 1x per minute though it would be better if
I could schedule & re-schedule procedure start time from within a trigger or
other stored procedure. The recurring stored procedure is NOT an
administrative maintenance task. The recurring procedure calls other stored
procedures across servers to gather data for the application.

Question:

1) What's the preferred way to schedule & reschedule recurring execution of
an application's stored procedures? From reading Books Online I gather that
SQL Server Agent and DTS can both schedule tasks? Is one of those two
approaches appropriate for my needs?

--Richard

Relevant Pages