Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Windows Service or SQL Job?

I have an archiving process that basically deletes archived records after a set number of days. Is it better to write a scheduled SQL job or a windows service to accomplish the deletion? The database is mssql2005.

Update:

To speak to some of the answers below, this question is regarding an in house application and not a distributed product.

like image 842
Aaron Palmer Avatar asked Oct 30 '08 15:10

Aaron Palmer


1 Answers

I would think a scheduled SQL job would be a safer solution since if the database is migrated to a new machine, someone doing the migration might forget that there is a windows service involved and forget to start/install it on the new server.

like image 85
Jimoc Avatar answered Oct 12 '22 13:10

Jimoc