• You cannot update emp again from an after trigger (could cause looping). Try a before insert trigger.

    Ps why are you updating the whole table (status=1) for each row?