Does Stock SIP work on market holidays?

No, Stock SIP orders are placed only on trading days. If the SIP date falls on a market holiday, the order is usually placed on the next working day.