A job is the easiest way to do it, but not the only way. You could setup a service broker queue to run the proc every night at the same time. You could setup an infinite loop proc that only executes the stores procedure when you want it.

However, for what you are looking for, a job is probably the easiest and most efficient way to do it.

Nabha hit the nail on the head for the rest of it.

Fraggle