I am always of the opinion that DBA will do it when needed.
This link maybe helpful.
Thank you for this document, but I have done reading this document. Do you have any script or something in relation to my above asked question?
I usually use cron job, unix, which is quite handy for me. So what I do is put the scripts in unix(using bteq),it may be ksh I always use, then.
30 1 * * * /home/lastDayOfMth && /path/my_script.ksh.(just example)
Please change the parameters accordingly.