We manually run a daily query to extract all OPEN DEPLOYMENTS. Is there a way to automatically run this query at a specific time each day and output the results to a common location?
What't the best way to achieve this?
This topic has been locked.
Pinned topic automatically run this query at a specific time？
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
martina 110000RMP6195 Posts
Re: automatically run this query at a specific time？2010-05-25T15:02:23ZThis is the accepted answer. This is the accepted answer.You will want to write a cqperl script that runs your report and schedule it via "Scheduled Task" or cron or ClearCase scheduler.
Don't Postpone Joy - Have Fun
IBM Rational Certified Consultants
IBM Business Partner
SystemAdmin 110000D4XK24948 Posts
cglockner 2700009784345 Posts
Re: automatically run this query at a specific time？2010-05-25T15:28:49ZThis is the accepted answer. This is the accepted answer.Hello,
Your only option would be using a Scheduled Task (Windows) or a cron job (UNIX/Linux) and the ClearQuest API to run a query and produce whatever output you need.