<div>
To automate, you can use powershell cmdlets to access SQL and using windows task scheduler to manage when your powershell script runs.<br />
<br />
Scheduling the running of your powershell script.<br />
Schtasks /?<br />
Schtasks /create /?<br />
<br />
Express versions do not have SQL agent option to schedule SQL jobs.<br />
<br />
There are many examples powershell SQL scripting including creating backups if the DBs.
</div>


To automate, you can use powershell cmdlets to access SQL and using windows task scheduler to manage when your powershell script runs.

Scheduling the running of your powershell script.
Schtasks /?
Schtasks /create /?

Express versions do not have SQL agent option to schedule SQL jobs.

There are many examples powershell SQL scripting including creating backups if the DBs.

<div>
<div class="content wysiwyg-content">
I have a small SQL 2008 r2 Express setup that has a few tables that I purge from within the management console now, by running a SQL script. &nbsp;I would like to find a way to automate that to run each night. &nbsp;Is there a tool in Express to do that or some other tool available to handle this? &nbsp;Will SQLCMD work for this? &nbsp;Thanks
</div>
</div>


I have a small SQL 2008 r2 Express setup that has a few tables that I purge from within the management console now, by running a SQL script.  I would like to find a way to automate that to run each night.  Is there a tool in Express to do that or some other tool available to handle this?  Will SQLCMD work for this?  Thanks

A way to automate a SQL script in 2008 r2 Express

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.