Topic
3 replies Latest Post - ‏2010-05-25T15:28:49Z by cglockner
SystemAdmin
SystemAdmin
24948 Posts
ACCEPTED ANSWER

Pinned topic automatically run this query at a specific time?

‏2010-05-25T13:22:40Z |
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?

Thanks
Jirong
Updated on 2010-05-25T15:28:49Z at 2010-05-25T15:28:49Z by cglockner
  • martina
    martina
    195 Posts
    ACCEPTED ANSWER

    Re: automatically run this query at a specific time?

    ‏2010-05-25T15:02:23Z  in response to SystemAdmin
    You will want to write a cqperl script that runs your report and schedule it via "Scheduled Task" or cron or ClearCase scheduler.

    Martina
    Don't Postpone Joy - Have Fun

    ReleaseTEAM Inc
    http://www.releaseteam.com
    IBM Rational Certified Consultants
    IBM Business Partner
    • SystemAdmin
      SystemAdmin
      24948 Posts
      ACCEPTED ANSWER

      Re: automatically run this query at a specific time?

      ‏2010-05-25T15:15:52Z  in response to martina
      Thanks and I also found this:
      http://www.ibm.com/developerworks/rational/library/3900.html
  • cglockner
    cglockner
    345 Posts
    ACCEPTED ANSWER

    Re: automatically run this query at a specific time?

    ‏2010-05-25T15:28:49Z  in response to SystemAdmin
    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.

    -Christian