Microsoft SQL Server forum - How to schedule a stored procedure

Author

How to schedule a stored procedure

Ranjit

2005-12-22, 3:24 am

I'm new to sql server programing. Please help me to scedule a stored
procedure to run every hour. Thnak you all.

Jens

2005-12-22, 3:24 am

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.

Ranjit

2005-12-22, 3:24 am

Can u please illustrate it more ? How ro set up a new job ?

Jens

2005-12-22, 3:24 am

MSDN is your friend:

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

HTH, jens Suessmeyer.

Greg D. Moore \(Strider\)

2005-12-22, 7:23 am

"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.

Sponsored Links