Run specific procedure daily at certain time, how?

  • i have a procedure (well working on it) that will be checking for some requests and if their status is incomplete - then it would send out emails through sp_smtp_email

    How can I make that procedure to run every day let's say at 6:00am?

    We run IIS 6.0 with MS Sql server.

  • create a Job that is scheduled to run once a day at that time and set it so that on the step call your stored procedure

     


    * Noel

  • I'm not familiar with Windows-based stuff.... where such job can be created?

  • I am not talking about windows I am talking about MS SQL Server Agent Jobs. On EM expand Management node on the server where your procedure is. Then Expand Management->SQL Server Agent->jobs and right click and select "create a new". I would definitly recommend you read BOL before you go through the UI to setup the job so that you get an understanding of the process first.

      


    * Noel

  • Alright, thank you. I never even paid attention to Management section in EM =)

Viewing 5 posts - 1 through 4 (of 4 total)

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