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.

No comments:

Post a Comment