How to schedule a stored procedure

Posted on 2016-09-20
Medium Priority
Last Modified: 2016-09-20
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.
Question by:maximus1974
LVL 71

Expert Comment

by:Éric Moreau
ID: 41807188
Do you see SQL Agent in Management Studio? This is where you will be able to schedule tasks
LVL 70

Expert Comment

by:Scott Pletcher
ID: 41807288
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.
LVL 44

Accepted Solution

zephyr_hex (Megan) earned 2000 total points
ID: 41807300
You won't choose a stored procedure.  You'll execute a command:

Create a new job, add a new step to the job and give it a name, and enter in your command that runs the stored procedure.  Make sure you select the database, and the proxy that should run the job in the Run As drop down.  Then go through the other settings (Schedule, etc) and configure the job.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question