automatic running

Results 1 to 2 of 2

Thread: automatic running

  1. #1
    Join Date
    Dec 1969

    Default automatic running

    Is it possible to create a stored procedure to run at midnight every night? If so, how may this be accomplished. I can only find information on how to run it at startup.

  2. #2
    Join Date
    Dec 1969
    Indianapolis, IN

    Default RE: automatic running

    You could set up a job to do this. Under Management, click on Jobs. Then right click for the option "Create New Job". Make it a one-step job that has the line: EXEC mystoredprocedure<BR>Then on one of the tabs, set it to run every night at midnight. It&#039;s very straight-forward to use. This is SQL Server we&#039;re talking about, I hope. Otherwise, I don&#039;t know.

Posting Permissions

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