Link to home
Create AccountLog in
Avatar of maximus1974
maximus1974

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.
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

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.
ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account