Post reply

Proc needs to run at a set time everyday

  • March 22, 2004 at 11:26 am

    #65887

    Can anyone tell me how to run a proc at a set time..

    i mean i want this proc to run every night at 11pm..

    how can i do this??

    thanks a lot

     

     

  • March 22, 2004 at 12:14 pm

    #499845

    Schedule it via Jobs.

    In Enterprise Manager drill down to Management. Then drill down to Jobs. Right click on jobs and select new job. Fill out the information.

    In the Steps tab you will set the commands to run. For example: EXEC my_sp_runthis

    Then on the Schedule tab you'll set the time and days you want it to run.

    -SQLBill

  • March 22, 2004 at 2:13 pm

    #499876

    thanks

    working on it now..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply