Add a job step in SQL Server 2005

Question

Hi,

I have a questions about creating a SQL Job. Can somebody please let me know that how we can add a job step in the middle. Like if I want to add a step between step 2 and step 3. I would really apprecaite it.

Thanks,

Answer 1

1. Go to SQL Server Agent
2. find the job that you want to modify and right-click and select Properties.
3. Under Steps, add a new step, put in what you need to do then OK to confirm.
4. Then order the steps and OK to confirm.