Scheduling a job in DBQL

General

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,

3 REPLIES

Re: Scheduling a job in DBQL

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_maint...

Cheers,

Raja

Re: Scheduling a job in DBQL

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?

Re: Scheduling a job in DBQL

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