The Job History Report provides data similar to that shown in the Execution History Query.
The report lists all instances of selected jobs that ran within a specified date range, optionally filtered by status.
|
|
This report is built from the job's execution history. The history retention settings for the job therefore must be set to retain the history long enough for you to report on it. For example, if you plan to run the Job History Report at the end of each month, you must make sure that the job's history will be saved for at least one month. If no history records exist for part of the date range you have specified for your report, the report will be incomplete. |
Information on the report can be grouped as follows:
No grouping. The report lists all instances in chronological order.
Status. The report groups the instances by their status. Within each status, instances are listed in chronological order. The report displays the total number of instances for each status.
Status and Job. The report groups the instances by their status. Within each status, instances are grouped by job, then listed in chronological order. The report displays the total number of instances for each status and for each job within a status.
Job. The report groups the instances by job. Within each job, instances are listed in chronological order. The report displays the total number of instances for each job.
Job and Status. The report groups the instances by job. Within each job, instances are grouped by status, then listed in chronological order. The report displays the total number of instances for each job and for each status within a job.
This report uses a direct database connection, which may require additional configuration. See the Direct Database Connection topic for more information.
See Also
