We help IT Professionals succeed at work.

Maintenance Plan - Run Stored Procedure

slattbr asked
What is the best way to run an existing stored procedure in a maintenance plan.

Ex:  I have a stored procedure (sp1) in database (db1) that I want to schedule to run.

Watch Question

The most reliable, secure and efficient way is to create a SQL Server Agent job, add a task, within the task call your storedproc and finally create a schedule for the job so it runs as frequently as needed on the specified days/times.


Very simple explanation. Worked great.  Thanks for the help.