HEXAQ : A friendly question - answer site for IT professionals

Which one is better for scheduled tasks Windows Service vs SQL Job?


We have SQL Server 2008 installed in our server. I have some tasks to do on regular basis.

Any one can suggest which one is better to run scheduled job either Windows Service or SQL Server Job? Why?

Please provide a useful link that I can follow.

Thanks in adv.


≡ Total 1 Answer


Windows Service is better as you can update them easily. Even from command prompt. A scheduled task manager can be used to start and stop the service.

I've faced many issues in SQL Server Jobs for continuity and in updating them.

My preference is Windows Service!


Enter your reply here
Answer Preview: