I have about six stored procedures that need to run every night to verify
data values against preset values and then perform some calculations.
Does anyone have a suggestion on a preferred method for scheduling stored
procedures. We are running Enterprise Server v12 on a NT 4 server. Possible
options I have considered.
-Use a Waitfor command?
-Schedule the procedure with a AT command?
-Build a VB script to replace the stored procedure and schedule the VB
script with an AT command?

Please let me know if anyone has any suggestions on the optimal method and
if anyone has any examples of recommended code.

Thanks.