Create a job.....under that you will steps add yout sp statement in that click ok..below that step one more thing is with schedule under that you can schedule ..for how...
Some ids of student table will present in school table...i am not dding inner join..if i go for inner join..will get all rows which were common based on id