how to write job scheduler programs to fetch all emails

See more:

scheduler

email

ASP.NET4

Hi ALL,

I've a requirement. kindly say me the functional feasibility. I need to fetch all emails from mail server we use. I've a web application which runs without internet. So I decided to automatically fetch emails from mail server and direct to SQL SERVER(2008) storing from, subject,body and datetime in tables(our database).

My doubt is how to write job scheduler program in SQL Server which should automatically fetch all emails and should insert in my table for every 30minutes.