This table is typically used by Unicenter Asset Management. It describes the various Jobs defined in the UAM Asset system. Each entry in the table defines a job. Each job has a unique DOMAINID and JOBID key. The JOBID field is crossed in the LINKJOB table to make a Job active on a Unit/Group of Units. The JONAME holds the display title of the job. The following job types (JOTYPE field) are known: ACMessage = 1 ACCommand (batch job) = 2 ACBackup = 3 ACSync = 4 ACExternal = 8 ACSystemBackup = 9 ACEngCollect (engine collect) = 10 ACEngQuery (internal engine task) = 11 ACScript = 14 ACHelpDesk (not available) = 15 ACRepository = 25 ACSQLScript = 26 ACServerInventory = 27 ACTng (engine TNG synchronization) = 28 ACDirectoryServiceSync = 29 ACWorldviewUnits = 30 The JOCMD and JOCONT fields define the job contents. These fields are formatted differently depending on the type of job and the format is private. JOCREATE and JOMODIFY indicate the date/time when the job was created/last modified. The JOFREQ field is the scheduled execution frequency. A value of 0 means the job should run always, 1 means once, other positive numbers indicate how many times the job should run. JOSDATE, JOSTIME, JOEDATE and JOETIME determine the scheduling time dependencies. They allow you to specify a specific date/time the job should execute. As usual dates are in seconds after 1970 and time is seconds after 00:00. A value of 1 in JOREMOVE causes the job to be removed when the status is set to OK (see the STATJOB table). The JODEPFIL text field can contain a filename that the Agent will test the presence of before executing the job. JOQUEST, JOQFORCE and JOQFDATE are used to show a dialog on the Agent before launching the job and to force the execution if the cancel option is chosen in the dialog. JOPARTNR is the part number of the job contents JOCONT. If the contents cannot fit one database entry, the JOPARTNR will be 1 or more and the complete contents can be read from the NCJOBBIN. REVNR is an internal version number, which is incremented each time the job is modified. USERID is the Admin Console User who created the job. Admin Console Users are defined the USERSEC table. CHECKSUM is a simple checksum calculated on the table entry and ensures that the contents is not tampered with. You are not to modify the contents of the job and doing so will cause the Engine software to refuse to distribute the new contents to the local databases (Sectors).
| Column Name | Column Datatype | Column Null Option | Column Comment |
| jobid | integer | not null | Unique Job ID |
| domainid | integer | not null | Domain ID. Foreign key to ca_n_tier |
| joname | nvarchar(127) | with null | Name of job |
| jotype | integer | with null | Job Type |
| jocont | nvarchar(14500) | with null | Job Contents |
| jocmd | nvarchar(127) | with null | Additional contents |
| joos | integer | with null | Operating System supports job |
| jocreate | integer | with null | Created Date |
| jomodify | integer | with null | Last Modified Date |
| josdate | integer | with null | Scheduling data - Start Date |
| jostime | integer | with null | Scheduling data - Start Time |
| joedate | integer | with null | Scheduling data - End Date |
| joetime | integer | with null | Scheduling data - End Time |
| jofreq | integer | with null | Run once (1), always (0), # of times (x) |
| josched | nvarchar(127) | with null | Execute on weekday (Sun Mon Tue Wed Thu Fri Sat) |
| joinst | integer | with null | Number of clients that can run the job in this sector |
| joonceat | integer | with null | Run Once at: 0=none, 1=Once a day, 2=Once a week, 3=Once a Month, 4=Once a year |
| jooncenr | integer | with null | Time units refering to above. |
| joflag | integer | with null | Logon /logoff |
| joexit | integer | with null | Should system restart after job run? |
| jddomid | integer | with null | Depend job domain id |
| jodepend | integer | with null | Job ID to depend on. |
| joquest | nvarchar(127) | with null | Ask question |
| joqforce | integer | with null | Count of questions denials before job force |
| joqfdate | integer | with null | Date of questions expiration before job force. |
| jologoff | nvarchar(127) | with null | Logoff text |
| joremove | integer | with null | Remove Job when executed. (when successfull execution of Job has been done by Agent it was scheduled to, Engine will remove the job) |
| jodepfil | nvarchar(127) | with null | File to depend on |
| jodevice | nvarchar(127) | with null | Device to connect before executing job |
| joserv | nvarchar(127) | with null | Share to connect JODEVICE with. |
| jodiscon | integer | with null | Disconnect device after execution. |
| joiconid | integer | with null | Job Icon ID. Not Supported any longer. |
| jopartnr | integer | with null | If JOCONT > 32000 Bytes then contents also in NCJOBBIN (JOPARTNR=1) else all contents in JOCONT (JOPARTNR=0) |
| revnr | integer | with null | Revision Number of Job |
| userid | integer | with null | User who has created this job. |
| checksum | integer | with null | Internal checksum |
| auto_server_version | integer | with null | Version number used for updating Server. Automatically maintained by Rule. |
| auto_rep_version | date | with null | Modification Date. Automatically maintained by Rule. Used for replication. |
| job_uuid | byte(16) | with null | Unique Job uuid |
| job_category | integer | with null | Job Category |
| creation_user | nvarchar(255) | with null | User that created Job |
| creation_date | integer | with null | Date when job was created |
| last_update_user | nvarchar(255) | with null | Last user that updated the Job |
| last_update_date | integer | with null | Date when the Job was last updated |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| jobid domainid |
ncjobbin | jobid domainid |