Showing posts with label storedprocedure. Show all posts
Showing posts with label storedprocedure. Show all posts

Wednesday, March 28, 2012

How to schedule a stored procedure

I'm new to sql server programing. Please help me to scedule a stored
procedure to run every hour. Thnak you all.No problem, just set up a new job with s step "TSQL" execution. You can
schedule that like any other jon in SQL Server.

EXEC SPSomeProcedure

HTH, jens Suessmeyer.|||Can u please illustrate it more ? How ro set up a new job ?|||MSDN is your friend:

http://msdn.microsoft.com/library/d...tomaem_19is.asp

HTH, jens Suessmeyer.|||"Ranjit" <mahalwarawa@.gmail.com> wrote in message
news:1135231814.534191.117420@.g44g2000cwa.googlegr oups.com...
> I'm new to sql server programing. Please help me to scedule a stored
> procedure to run every hour. Thnak you all.

Use the SQL Server Agent. Best bet in your case may be to look for it in
the Enterprise Manager GUI.