January 30, 2012 at 3:06 pm
I'm not sure if this is the right place to post this, but from my research this is the best spot.
I have an EmployeeReviews table...and basically..when the date is 14 days before their review date..I want to have an automated email sent out to the Reviewer. I've seen a lot of suggestions, but nothing really concrete..mostly people just arguing that their way is best..not actually giving their way..so any help would be appreciated.
We run on a windows server. Microsoft SQL Server studio 2005 ... ISS 6.0 ...anything else just ask me...I'm looking for the best and preferred easiest way to get this done. thanks!
January 30, 2012 at 3:30 pm
so from what you have already seen/tested...what doesnt do as you would wish??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 30, 2012 at 3:48 pm
to be honest.. havent really tested anything..i really have no clue as to how to do this...from old posts i've seen..some people use windows task scheduler....and i saw one person say they used sql server agent for something similar..but there were no explanations on how to set up either one..or really anytihng other then two people going back and forth with "mine is better than yours' ..lol
January 30, 2012 at 3:52 pm
A simple SQLServerAgent job would do the trick.
How to set up a job: http://www.dailycoding.com/Posts/step_by_step_guide_to_add_a_sql_job_in_sql_server_2005.aspx
You will also need dbmail: http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm
Hope this helps.
-- Gianluca Sartori
January 30, 2012 at 4:08 pm
i will look at this tonight..and try it out tomorrow..thank you for you quick replies!
update 1: The sql server manager thing is ridiculously easy..cant wait to play with tomorrow!
January 31, 2012 at 10:13 am
awesome!!! works like a charm!!
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply