The system automatically creates job history data for all processes, reports, and/or computations that have been executed on the Costpoint web job server.
Use this screen to print or purge the history of processes, reports, and/or computations that have been executed on the Costpoint web job server, as follows:
The Job History report prints information related to each job, including the specific job and description, the parameter ID and description, the start and stop times, and any related function messages that were generated by the application, as applicable.
The Job History purge process permanently deletes the Costpoint web job server history from the database based on your selection criteria.
You should run the purge function whenever you need to clear unwanted job history data from your database. You can print the related report as often as you choose.
You cannot print or purge the history of processes, reports, and/or computations unless and until they have been executed on the Costpoint web job server.
What steps should I follow to submit a job to the job server?
Selection Parameters
Create and save the screen selection parameters to be used in the individual computation, process, or report application(s).
Job Groups (Optional)
If you want to organize your jobs into groups (for organizational purposes only), you should first create job groups in this screen.
Jobs
Set up the details of the specific job in the Jobs screen (Administration\Maintain\Job Management), including the name, description, and how the job should behave if an application task fails.
You must also enter one or more application tasks to be executed in the job as well as the parameter ID for each specific task.
Submit Job to Queue
Use the Submit Job to Queue screen (Administration\Transactions\Job Management) to select the timing parameters and specify the queue.
Click on the Submit to Queue pushbutton.
Which screens can I use to monitor and report on my jobs?
Job Report
Print this report (Administration\Review\Job Management) to review the jobs you have created in Costpoint web. This report lists the parameter ID(s) and sequential application(s) associated with each job.
Monitor Job Status
Use this screen (Administration\Transactions\Job Management) to view the job information and the status of jobs scheduled for a specific job queue.
|
|
Note: You can make edits to a job in this screen only if you submitted the job. |
Update Job Queue List Status
Use this screen (Administration\Transactions\Job Management) to make a queue active or inactive on the job server and to allow a new queue to be recognized when the job server is already running.
Print/Purge Job History
Use this screen (Administration\Utilities\Job Management) to print and/or purge the history of jobs that have been previously executed on the job server.
Process and Report Status Inquiry
Use the Process and Report Status Inquiry screen (Administration\Review\Job Management) to view job status by application.
Which job screens are normally the responsibility of a system administrator?
Job Queues
The system administrator will normally create the job queues for jobs to run in and can manage all job queues from this screen (Administration\Maintain\Job Management) based on the display of queue status and specific job information.
Start/Stop Job Server
The system administrator will normally manage the job server operation from this screen (Administration\Transactions\Job Management) via the Start, Stop, and Reset pushbuttons and the Daily Shutdown Time and Daily Restart Time fields.
Job queue activation/deactivation can also be controlled from this screen.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID, you can retrieve it along with the saved parameters using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
The checkbox (top right corner) allows you to select/deselect the record. You might select this checkbox if you want to mark the record for deletion, for example.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to select the job, submitting user, start date, and completion date selection criteria for the print/purge, as applicable.
Job (Option)
Select the job option from the drop-down box. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
The default selection for this field is "All."
Enter, or use Lookup to select, the starting job, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single job. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field will be disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, you must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the ending job, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single job. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field will be disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, the End field will be disabled. You must enter the value from which the range should begin in this field.
Submitting User (Option)
Select the desired submitting user ID option from the drop-down box. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
The default selection for this field is "All."
Enter, or use Lookup to select, the starting submitting user ID, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single submitting user ID. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field will be disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, you must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the ending submitting user ID, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single submitting user ID. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field is disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, the End field is disabled. You must enter the value from which the range should begin in this field.
Start Date (Option)
This drop-down box is available for selection only if you have selected the Users radio button in the Show group box within the Options block. [If you have selected the Rights radio button, this drop-down box is disabled.]
Select the desired job start date option from the drop-down box. The following options are available, as applicable:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
The default selection for this field is "All."
This field is available for selection only if you have selected the Users radio button in the Show group box within the Options block. [If you have selected the Rights radio button, this drop-down box is disabled.]
Enter, or use Lookup to select, the job start date, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single job start date. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field is disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, you must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
This field is available for selection only if you have selected the Users radio button in the Show group box within the Options block. [If you have selected the Rights radio button, this drop-down box is disabled.]
Enter, or use Lookup to select, the ending job start date, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single job start date. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field will be disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, the End field will be disabled. You must enter the value from which the range should begin in this field.
This drop-down box is available for selection only if you have selected the Users radio button in the Show group box within the Options block. [If you have selected the Rights radio button, this drop-down box is disabled.]
Select the desired job completion date option from the drop-down box. The following options are available, as applicable:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
The default selection for this field is "All."
This field is available for selection only if you have selected the Users radio button in the Show group box within the Options block. [If you have selected the Rights radio button, this drop-down box is disabled.]
Enter, or use Lookup to select, the starting job completion date, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single job completion date. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field will be disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, you must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
This field is available for selection only if you have selected the Users radio button in the Show group box within the Options block. [If you have selected the Rights radio button, this drop-down box is disabled.]
Enter, or use Lookup to select, the ending job completion date, as applicable.
The following system restrictions are enforced:
If you have selected "One" as the selection range, you can only select a single job completion date. The End field is disabled for this option.
If you have selected "From Beginning" as the selection range, the Start field will be disabled. You must enter the last value for the range in the End field.
If you have selected "To End" as the selection range, the End field will be disabled. You must enter the value from which the range should begin in this field.
Use the field in this block to specify the number of days prior to the current date to purge, based on the job completion date.
Enter the number of days prior to the current date to purge, based on the job completion date. [The completion date is stored as the ACT_COMPLETE_DTT field in the JOB_SCHEDULE_HIST table.]
All processes, reports, and/or computations) that fall within that range and that also meet your other selection criteria (jobs, submitting users, start dates) will be printed and/or purged.
|
|
Note: For example, if the current date is 3-14-05, if a job completed on 12-31-04, and you specify "60" in this field, the application will print and/or purge job server history data in the range from the current date out to the number of days prior to the current date. Current Date: 3-14-05 Data in JOB_SCHEDULE_HIST table, ACT_COMPLETE_DTT field: 12-03-04 12-16-04 2-15-05 3-14-05 Days Prior to Completion: 1-26: 3-14-05 27-87: 3-14-05, 2-15-05 88-100: 3-14-05. 2-15-05, 12-16-04 101: 3-14-05, 2-15-05, 12-16-04, 12-02-04 |
If you select any range option other than "All" in the Select Completion Dates group box, this field should not be used. The system will display an error message if you try to enter data for both the Completion Date selection option field and this field.
* A red asterisk denotes a required field.
|
|
Note: You can print a purge list prior to the purge or you can purge the data without first printing a purge list.
|
This report accesses data from the JOB_SCHEDULE_HIST (Job Schedule History) and JOB_SCHEDULE_LOG (Job Schedule Log) tables.
