• There are several ways, but I would create 2-step job using your 2 scripts and put something like

    if (select count(*) from FROM [ReorderS]) > 0

    in the beginning of second step.