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.
3 replies Latest Post - 2010-05-25T15:28:49Z by cglockner
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.
Updated on 2010-05-25T15:28:49Z at 2010-05-25T15:28:49Z by cglockner
martina 110000RMP6194 PostsACCEPTED ANSWER
Re: automatically run this query at a specific time？2010-05-25T15:02:23Z in response to SystemAdminYou 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
cglockner 2700009784345 PostsACCEPTED ANSWER
Re: automatically run this query at a specific time？2010-05-25T15:28:49Z in response to SystemAdminHello,
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.