Thanks a lot for everyone's quick response. What an awesome community we have here. I would have never been able to figure this out on my own. Thanks a lot @cmcclellan for your detailed explanation and the workflow. I will recreate this by following the dataschool and your instructions.
Regarding updating URL with the time, do I have to do this every time before running the job? This is a weekly job that that I was planning to automate.