automatic stored procedure?

Posted on 2006-04-04
Medium Priority
Last Modified: 2008-01-09
I am writing a SP that is being executed daily or weekly. Just want to get some starting points. If you have any suggestions or samples, please let me know.
Question by:khinklenj

Assisted Solution

acampoma earned 500 total points
ID: 16376289
use a sql Agent job to schedule the execution of your SP
LVL 34

Accepted Solution

Brian Crowe earned 500 total points
ID: 16376306
Sounds great...what are you asking?  How to schedule it to run on a recurring basis?

Management -> SQL Server Agent -> Jobs
Create a new job either placing the stored procedure code in a new step or just execute the stored procedure, set the schedule, you're done.

Author Comment

ID: 16376535
I have sql server 200- developer edition. Do you think i can do this from my sql server client?
LVL 34

Expert Comment

by:Brian Crowe
ID: 16376558
you can do it from enterprise manager.
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 16377828
One more option :

create a DOS batch file say 'schedule.bat' containing the following Query

osql -E  -H-1 -Q "select *exec urSpName urArgs"

You can shcedule this batch file to run using Windows Task Scheduler

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

864 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