Thanks Nathan,
But, My functionality needs to re-run the procedure as and when required. If I use the way you did then it may only run on the 1st of every month. The case of running it again as and when required will fail. Sorry, for not intimating about this functionality earlier. Please suggest me a way to run the proc on 1st and also the user must have a provision to run it again, if needed..
Thanks again..
