Addressing query scheduling and system resource requirements
AssigneeInternational Business Machines Corporation
InventorsRichard D. Dettinger, Daniel P. Kolz, Shannon E. Wenzel
Life of this patent
Estimating the term…
Abstract
Method, system and article of manufacture for scheduling queries. In particular, the scheduling options made available to a user for a particular unit of work are determined dynamically at the time of scheduling. In this way, the execution cost, for example, of a particular unit of work can be taken into account when determining which scheduling options to make available. In addition, or alternatively, system availability and/or user parameters may be accounted for when determining which scheduling options to make available.
Claims14
A non-transitory computer readable storage medium containing a program which, when executed, performs an operation for scheduling execution of units of work, the operation comprising:
- determining a first cost to execute a first unit of work;
- determining a first set of user-selectable scheduling options for future execution of the first unit of work based on the first cost, wherein the first set of user-selectable scheduling options is a subset of a larger set of scheduling options, and wherein the larger set of scheduling options are stored on a computer readable storage medium and include a plurality of user-selectable time criteria and frequency criteria, wherein the time criteria specifies when the execution of a given unit of work will begin and the frequency criteria specifies how frequently the given unit of work will be executed;
- returning the first set of user-selectable scheduling options to a user interface for display, whereby the user interface presents:
- time criteria selection elements from which a user specifies a time at which execution of the first unit of work will begin;
- and
- frequency criteria selection elements from which the user specifies a frequency at which the first unit of work will be executed beginning at the specified time;
- determining a second cost to execute a second unit of work;
- determining a second set of user-selectable scheduling options for future execution of the second unit of work based on the second cost, wherein the second set of user-selectable scheduling options a subset of the larger set of scheduling options, and wherein the second set of user-selectable scheduling options is different than the first set of user-selectable scheduling options;
- and
- returning the second set of user-selectable scheduling options to a user interface for display, whereby the user interface presents:
- time criteria selection elements from which a user specifies a time at which execution of the second unit of work will begin;
- and
- frequency criteria selection elements from which the user specifies a frequency at which the second unit of work will be executed beginning at the specified time.
A computer system, comprising:
- a schedule indicating when units of work are to be executed;
- a scheduler configured to:
- determine a first cost to execute a first unit of work;
- determine a first set of user-selectable scheduling options for repetitive execution of the first unit of work on the basis of the first cost, wherein the scheduler determines the first set of user-selectable scheduling options base on the first cost, wherein the first set of user-selectable scheduling options is a subset of a larger set of scheduling options, and wherein the larger set of scheduling options are stored on a non-transitory computer readable storage medium and include a plurality of user-selectable time criteria and frequency criteria, wherein the time criteria specifies when the execution of a given unit of work will begin and the frequency criteria specifies how frequently the given unit of work will be executed;
- return the first set of user-selectable scheduling unit of work to the user interface for display, whereby the user interface presents:
- time criteria selection elements from which a user specifies a time at which execution of the first unit of work will begin;
- and
- frequency criteria selection elements from which the user specifies a frequency at which the first unit of work will be executed beginning at the specified time;
- determine a second cost to execute a second unit of work;
- determine a second set of user-selectable scheduling options for repetitive execution of the second unit of work on the basis of the second cost, wherein the scheduler determines the second set of user-selectable scheduling options based on the second cost, wherein the second set of user-selectable scheduling options is a subset of the larger set of scheduling options, and wherein the second set of user-selectable scheduling options is different than the first set of user-selectable scheduling options;
- and
- return the second set of user-selectable scheduling unit of work to the user interface for display, whereby the user interface presents:
- time criteria selection elements from which a user specifies a time at which execution of the second unit of work will begin;
- and
- frequency criteria selection elements from which the user specifies a frequency at which the second unit of work will be executed beginning at the specified time.
Dependencies are inferred from the claim text.