CODEWITHSUNDEEP
asp.netsql-server
George Johnston
George Johnston

Reputation: 32258

SQL Express -- Cleaning House, Automation

When we develop an ASP.NET client site, we deploy a SQL Server Express database along with it. We need to run a clean-up script to check for records older than n. hours, but unfortunately I cannot schedule a job do to the limitations of SQL Express. Are there any other alternatives or suggestions for automating clean-house that anyone may have had experience implementing?

Upvotes: 2

Views: 150

Answers (2)

Remus Rusanu
Remus Rusanu

Reputation: 294267

Use a conversation timer and run the maintenance from an activated procedure. Sign the procedure for cross-db or server wide access.

The big advantage is that is self contained in the database and survives across database copy and backup/restore operations (a scheduled 'job' will execute after a restore on a new system).

Upvotes: 4

D'Arcy Rittich
D'Arcy Rittich

Reputation: 171411

You could setup a Windows Scheduled Task that hits an ASP.NET page to do the clean up.

Upvotes: 0

Related Questions