I am working on SharePoint 2013 list. and i want to send emails and change the item status field, when a list column named "Review Date" is met , and by "met" i mean when the "Review Date" is equal to Today ...
now i read about the available approaches to accomplish such functionality, and seems there are 2 main approaches :-
create a workflow 2010 inside SharePoint designer 2013, which have a "Pause until date" action , which will update the item status & send an email , when the "Review Date" is met.
Or i can develop a timer job using visual studio, which will do the same thing as in the workflow scenario.
now i cam a bit confused on which approach is better, or what are the main differences between defining a "Pause until date" action inside a workflow 2010 & developing a timer job ? i came out with these points:-
if we consider the performance and the overhead of the server ?will creating a workflow for each list item , with a Pause Until action have more overhead on the server.. while having a timer job will win from performance perspectives ?
if i want to apply this checks on multiple lists ? which approach will be considered more extensible ?
are there other main differences i need to take into consideration?