All Forums General
omarsaeed22 17 posts Joined 11/13
01 Dec 2013
Scheduling a job in DBQL

Hi,
Can anyone please let me know that how to schedule a job in DBQL to move the data from DBQL to History tables.
 
Thanks and Regards,
 

MOHAMMAD OMAR SAEED
Raja_KT 1246 posts Joined 07/09
01 Dec 2013

Hi Omar,
I am always of the opinion that DBA will do it when needed.
This link maybe helpful.
http://d289lrf5tw1zls.cloudfront.net/database/dbql-scripts/TD13_0_and_TD13_10_DBQL_logging_and_maintenance.pdf
 
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

omarsaeed22 17 posts Joined 11/13
02 Dec 2013

Hi Raja,
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?
 
 
 

MOHAMMAD OMAR SAEED

Raja_KT 1246 posts Joined 07/09
02 Dec 2013

Hi Omar,
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.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.