I need to find out info on how to schedule a stored proc to run in sql 7 every few hours?

I have 2 stored proc's that i want to run an append query every 4 or 8 hours.
how does a person do this in ms sql 7?

Steve,

There are various methods but the easist would be to create a new job under SQL Server Agent. Create your job as T-SQL, type in the stored procedure you want to execute (exec <stored Procedure>) and then schedule it to run whenever you want.

Regards
Vincent


------------
steve at 8/24/99 4:36:37 AM

I have 2 stored proc&#39;s that i want to run an append query every 4 or 8 hours.
how does a person do this in ms sql 7?

Dead Easy !!! You can do this from Enterprise Manager ...

Create a New Job ( in Management, SQL Server Agent )
Type in a name for the job
Define the two stored procedures as the two steps
Add a new schedule of every few hours

... and thats it. Make sure SQL Server Agent is running as this manages the jobs.

OK??
Duncan

------------
steve at 8/24/99 4:36:37 AM

I have 2 stored proc&#39;s that i want to run an append query every 4 or 8 hours.
how does a person do this in ms sql 7?