Hi Shell,

Acccording to John, i have followed the below step

(1) Modify the code I posted so that it fits your environment

(2) Create a new job

(3) Copy and paste the code into the "Command" field

(4) Schedule the job to run with the desired frequency and at the desired times

Now how will i confirm myself that the 2nd sp gets executed only after 1st one finishes and so on??

U have any idea