schedule stored procedure

How to schedule a stored procedure to run at a certain system time in a regular basis?Use SQL Server Agent. You could configure SQL Server Agent jobs in Enterprise Manager or SQL Server Management Studio. Or by sp: sp_add_job, sp_add_jobstep, sp_add_jobschedule|||If you do not have SQL Agent available (you're using SQL 2005 Express), you can combine the use of SQLCmd.exe, Windows Scheduler, and Stored Procedures.