Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    65

    Unanswered: time based 'triggers'

    Hey,

    I have a few procedures I want to run at a set time every week.

    I know how to do it as a batch, but (for obvious security reasons) my host won't allow me to create batch files. Is there a way in MS SQL to make a stored procedure 'trigger' at say midnight every friday?

    If not, what's the best way to achieve a similar result?

    Thanks
    -Ashleigh

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    Go to SQl Server agent, make new job, make job step execute that procedure and then give the job the schedule you want...
    make one step per proc if you want to keep all of them in the same job..
    Des

Posting Permissions

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