I played around with the Datediff in the script just to test the script to get some results; I don't think this would apply here as we're telling it to refer to the ord_datetaken column which is a date datatype, so we're just telling it to go back 7 minutes as per the job schedule.

Do you have any reading material you can suggest for creating stored procs? I'm still "in training", learning as much as i can from the ground up and i haven't gotten to trying anything with SP.

I understand that once the stored proc is created, i would just have to have an EXEC function in the agent job and call the new SP. I'll see if we have any existing reports that work like this and I'll post an update tomorrow.

Thanks for the input Aaron!