-
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?
-
I need to find out info on how to schedule a stored proc to run in sql 7 every few hours? (reply)
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's that i want to run an append query every 4 or 8 hours.
how does a person do this in ms sql 7?
-
I need to find out info on how to schedule a stored proc to run in sql 7 every few hours? (reply)
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's that i want to run an append query every 4 or 8 hours.
how does a person do this in ms sql 7?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|