<div>
You can create a job with the SQL you have and schedule it to run.
</div>


You can create a job with the SQL you have and schedule it to run.

<div>
Perfect. &nbsp;Thanks so much for the answer and quick response. &nbsp;No more weekend maintenance!
</div>


Perfect.  Thanks so much for the answer and quick response.  No more weekend maintenance!

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
&nbsp; &nbsp;I am betting this will be an easy question for some, but for me its pretty tough. &nbsp;I have an application that collects all of the event logs from all the servers in the domain and dumps them into a SQL Database. &nbsp;It works great but there are literally millions of records daily and the database will grow to 150 GB in a few months. &nbsp;Its not a big deal when I run something like this on a daily basis from SQL Query Analyzer...<br />
<br />
DELETE FROM [Domain Event Logs].[dbo].[Security]<br />
WHERE DateAndTime &lt;&nbsp;'4/1/2006 12:00:00 AM'<br />
<br />
However, if I am out of the office or dont run the script over the weekend I run into problems. &nbsp;I need to come up with a way to automate the deletion of old records so that I dont have to worry about it. &nbsp;I have read about the &quot;INTERVAL&quot; command but cant get it to work properly. &nbsp;The Server is 2003 Server STD and SQL 2000. &nbsp;Thanks for the help. &nbsp;I am assigning the max points because of the time I have wasted on the weekends doing maintenance on the database.
</div>
</div>


Hello All,

   I am betting this will be an easy question for some, but for me its pretty tough.  I have an application that collects all of the event logs from all the servers in the domain and dumps them into a SQL Database.  It works great but there are literally millions of records daily and the database will grow to 150 GB in a few months.  Its not a big deal when I run something like this on a daily basis from SQL Query Analyzer...

DELETE FROM [Domain Event Logs].[dbo].[Security]
WHERE DateAndTime < '4/1/2006 12:00:00 AM'

However, if I am out of the office or dont run the script over the weekend I run into problems.  I need to come up with a way to automate the deletion of old records so that I dont have to worry about it.  I have read about the "INTERVAL" command but cant get it to work properly.  The Server is 2003 Server STD and SQL 2000.  Thanks for the help.  I am assigning the max points because of the time I have wasted on the weekends doing maintenance on the database.

Daily Maintenance Script to delete records 45 days old

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.