Results 1 to 3 of 3

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

  1. #1
    steve Guest

    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?

  2. #2
    vincent mcguire Guest

    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&#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?

  3. #3
    Duncan Maddox Guest

    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&#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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •