Priya,
While scheduling the report, u select the destination as the inbox instead of a specified directory. Also r u getting any specific error message when the report fails. 1 more question what are the days u r selecting when scheduling the report on weekly basis?
i m asking these details because i m not getting any error while scheduling the same report on daily or weekly basis.
Please do the changes accordingly and let me know if the problem still exists