CLM ETL jobs
I want to change CLM ETL start time due to some ongoing issues. Currently its scheduled at 10 PM ( every 24 hours) and I want to change it to 7 PM.
To change the schedule, I logged in to: https://<Public-URL>/jts/admin#action=com.ibm.team.reportsManagement.configureDataWarehouseConnection
Then modified "Data Warehouse Snapshot Time" which was set to “22” and I changed it to “19”.
Also, I didn’t change "Task delay" - by default it is set to 86400 seconds (24 hours). I.e. the job will run every 24 hours.
Question – I am not sure if the same change needs to be done at CCM and QM admin pages as well OR JTS will take care of all.
Concern – After doing all this, job still started at 10 PM and NOT 7 PM.
Accepted answer
Hi, Sidharth
Yes, you will need the change to all applications start time.
The change will be effective after data collection job was triggered or you restart the server.
So you should be able to see the change after your collection jobs run at 10pm once. I had a similar question before and please see the details here:
https://jazz.net/forum/questions/102364/change-data-collection-job-start-time
Thanks
Comments
Hi Don Yang,
Thanks for sharing all the details. I agree to your point. However, I believe that JTS executes and handles jobs for CCM and QM as well.
Earlier also, the parameter was set to 22 for JTS and was default 24 for CCM and QM. Still all the jobs used to execute at 10 PM and NOT 12 AM. That's why i have raised this as a concern whether i need to modify the same in CCM and QM OR only JTS would suffice. Can you please confirm?
you are right, ETL schedule start time is controlled by JTS application.
Thanks Don Yang..Does it mean that the parameter should only be modified in JTS and NOT in CCM and QM?
Yes, JTS only should be fine.
Thanks a lot. Cheers!
Comments
Sidharth Chadha
Mar 21 '17, 10:26 a.m.CLM version is 4.0.3