title: How to create a scheduled job in SQL server 2008 via T-SQL?
body: <p>I want to create a job which deletes records from a database after a period of time has passed. For example I have a field in news table <code>Time Stamp</code> and each month a SQL query runs like a scheduled job against my database and deletes news where the time stamp is two month old. Generally I want to delete news for 2 month ago and older to not let my table become a large table. How can I accomplish this?</p>