You have choices. You can have SQL Server run the "job" (SQL name for a task) through the agent. The job can either be generated and scheduled through Management>SQL Server Agent or through the Import/Export DTS wizard. You can also set up a DTS package through Data Transformation Services and get it scheduled through SQL Agent.<BR>You can also create a VB exe which will do the job and will be kicked off via Windows Scheduler.<BR>Don't forget to incorporate some kind of failsafe so that if the overnight job fails, you know about through email (possible through Agent) or error log.<BR>Check out your search engine of choice or MSDN for more info.<BR><BR>Good luck.<BR><BR>Franco
>I think not You can also set up a DTS package through Data Transformation Services and get it scheduled through SQL Agent. <BR><BR>What has this to do with A stored Procedure -- He did not say what the Stored procedure was doing if I remember correctly, but anyhow you Would not use DTS to run a stored procedure Automatically.<BR><BR>DTS is Data Transformation Service.