asked on
How to schedule a stored procedure
i don't see a way to schedule a stored procedure in SQL server 2008. I am looking for the job wizard but I keep getting the new job window. when i schedule a step, it does not give me the option to choose a stored procedure.
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
zephyr_hex (Megan)
Do you see SQL Agent in Management Studio? This is where you will be able to schedule tasks
You schedule an entire job, not just a step.
Right-click on the Job, select "Properties", click on the "Schedules" tab, and create the schedule(s) you need from there.
Right-click on the Job, select "Properties", click on the "Schedules" tab, and create the schedule(s) you need from there.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.