Is there a way in sql agent job to move to the next step if the table is empty? In the first step I want to check whether the table is empty. If the table is empty then I want to move to the next step.
Sure. Just raise an error. Then, in the steps, you can have it decide what to do in the event of a failure or a success. So, if you want it to to go to the next step on a failure, but stop running on success, you make those changes in the advanced settings of the step you're working on.