August 1, 2005 at 1:34 pm
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.
August 1, 2005 at 1:51 pm
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
August 1, 2005 at 3:04 pm
I'm not familiar with Windows-based stuff.... where such job can be created?
August 1, 2005 at 3:36 pm
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
August 2, 2005 at 6:26 am
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