Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
How to schedule a stored procedureI'm new to sql server programing. Please help me to scedule a stored procedure to run every hour. Thnak you all.
Post Follow-up to this message
Re: How to schedule a stored procedureNo 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.
Post Follow-up to this message Re: How to schedule a stored procedureCan u please illustrate it more ? How ro set up a new job ?
Post Follow-up to this message Re: How to schedule a stored procedureMSDN is your friend: http://msdn.microsoft.com/library/d...> aem_19is.asp HTH, jens Suessmeyer.
Post Follow-up to this message Re: How to schedule a stored procedure"Ranjit" <mahalwarawa@gmail.com> wrote in message news:1135231814.534191.117420@g44g2000cwa.googlegroups.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.
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
