This table contains the status entries returned by the Agent when running a scheduled job. When a Job has run on the Agent it will return a status code (OK, ERROR, WAITING) and a possible status message string. Jobs are any batch job, external execution of application, Engine collect cycle or replication management scheduled for any Unit. The definition of jobs can be found in the NCJOBCFG table. Each entry in this table holds information about the status of execution of one job by an Agent. The UDOMID and UNITID are foreign key to the UNIT table and defines the Unit who reported the status. The JDOMID and JOBID are keys in NCJOBCFG and defines the job the status belongs to. The STATUS field will contain a code according to the returned Job error code: OK = 1 Error = 0 Waiting = -1 All Units who have no entry in this table are assumed to have a "Waiting" status. The STCOUNT field is incremented each time status is collected for that job. The STQCOUNT field is incremented each time the execution of a job is cancelled by a user (only possible if the scheduling properties allow the user to cancel the execution). STDATE is the date/time the job was executed. STELAPSE describes how many seconds it took to execute the job. The STTEXT field contains the status text string returned by the Agent. This string can only be 127 characters long. If the returned status field exceeds this limit, the STFLAG will indicate that the STATJOBM table contains the complete status text. STREV is an internal version number, which is incremented whenever the job properties are updated.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| jobid | integer | not null | Job ID. Foreign Key to NCJOBCFG |
| jdomid | integer | not null | Job domain ID. Foreign Key to NCJOBCFG |
| object_uuid | byte(16) | not null | Object Uuid. Foreign key to either ca_discovered_hardware or ca_discovered_user depending on object_type (1=ca_discovered_hardware,2=ca_discovered_user) |
| status | integer | with null | Status (1=OK, 0=Waiting, -1 Error) |
| stcount | integer | with null | Number of times executed |
| stqcount | integer | with null | Number of times cancelled |
| stdate | integer | with null | Date for last Execution |
| stelapse | integer | with null | Elapsed time for Execution (Seconds) |
| sttext | nvarchar(127) | with null | 127 characters Status Text |
| strev | integer | with null | Revision Number |
| stflag | integer | with null | More status (0=None,1=More look in STATJOBM) |
| auto_rep_version | date | with null | Modification Date. Automatically maintained by Rule. Used for replication. |
| object_type | integer | with null | Object Type. 1=ca_discovered_hardware,2=ca_discovered_user |
| object_domain_uuid | byte(16) | with null | Object domain uuid. Foreign Key to ca_n_tier. Used for replication purposes. |
Product Name: Unicenter Desktop and Server Management
Table Type: Table