Hello,
How can I run one of my stored procedure every 30 minutes in SQL Server 2000
?
Thanks,Just schedule a job. Goto Management, SQL Server Agent, Jobs, New Job.
Specify the jobs Steps, Type Transact-SQL Script, select your database, and
specify the schedule Recurring, Daily, Ocurrs every 30 Minutes. Perhas I am
missing something but these are the most important steps.
Ben Nevarez, MCDBA, OCP
Database Administrator
"JIM.H." wrote:
> Hello,
> How can I run one of my stored procedure every 30 minutes in SQL Server 20
00?
> Thanks,
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment