When that trigger price is reached on a Stop Limit order, the buy or sell order is automatically posted as a regular limit order.
At that point, the limit order will remain active until the end of day. Any limit order created by a stop limit order will expire if not filled before the end of the day.