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

    Unanswered: time based 'triggers'


    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?


  2. #2
    Join Date
    Jun 2003
    cape town, south africa
    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..

Posting Permissions

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