This is the JAS master job table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| joid | decimal(15) | not null | Unique job id. Each unique id is generated on the central, control server. The ids are unique within the nodes managed by that central server. ( generate from mitjas_setup table.) |
| groupid | decimal(15) | with null | Strategy group id. Can determine the strategy id by looking up the StrId in the Strategy_Group row. |
| username | varchar(50) | with null | Reserved for future use |
| userrole | varchar(125) | with null | Reserved for future use |
| node | varchar(60) | with null | Node this job will run on. |
| deployed | decimal(15) | with null | This is a time_t timestamp, in GMT, of when the job was written into the job table on the node in which it will run. This is also used as the job creation time. |
| next_start | decimal(15) | with null | Time_t timestamp. This is the next time, in GMT, to run this job. This is set using the calendar and recurrence information the next time the job is started. If the value is < zero, it has the following meaning: 1 = This job is to be run immediately. 2 = This job is expired 3 = This job is not scheduled ("Schedule later") |
| command | varchar(255) | with null | Along with CommandB, this is the command line to execute. Because of database VARCHAR size limitations, this needs to be split in 2 pieces by the API and reassembled to invoke. |
| commandb | varchar(255) | with null | See the Job.Command column |
| runcount | integer | with null | Number of times the job has been run. At each start of a job, RunCount is incremented and stored in JobHistory.Run_Num. |
| timezone | integer | with null | 1 = Use time zone of the node where the job will run 2 = Use time zone of the node where the job is scheduled from (local workstation's time zone). Must convert from client's time zone convention to whatever time zone convention JAS ends up using. It is used to convert the time to GMT. The API will retreive the time zone's offset from GMT and adjust the time to GMT. |
| wstimezone | varchar(12) | with null | Timezone of the workstation from which this job is scheduled. This is used by the scheduler if TimeZoneNode=2 to adjust the time. |
| retryinterval | integer | with null | In minutes. After a preempted run, this is the number of minutes to wait before attempting to re-run the job. If zero, the job will not be re-run after being preempted. A preempted run is a job that did not run because the point product determined that it should not run due to point product specific operating rules. |
| retrycount | integer | with null | Number of retry attempts to make if the job has been preempted or was unable to start. If zero, the job will not be re-run after preemption or start failure. This does not control reruns after a point product failure. |
| n_retrys | integer | with null | Number of failed (point product) runs to accept before stopping the rescheduling of the job. This value is moved to "RecurFailureCount" upon job creation and everytime the job runs sucessfully (see "RecurFailureCount" for more info). This field will help control "runaway" job re-scheduling for jobs that never run correctly. |
| recurfailcount | integer | with null | This is used to test if the job has failed for a given number of succesive runs. It is decremented each time the job fails and reset to it's original value (RecurFailureThreshold) each time a job is successful. If the value ever gets to zero, the job will not be rescheduled. |
| notificationemail | varchar(185) | with null | Email address to send job completion notification to. Optional. |
| completionscript | varchar(185) | with null | Script to run upon successful completion. |
| failedscript | varchar(185) | with null | Script to run upon failure. |
| productcode | varchar(8) | with null | Product code that created the job. This should be the CA TOPS code. |
| productversion | varchar(8) | with null | Version number of the product that created the job. |
| description | varchar(128) | with null | Optional job description. |
| type | varchar(30) | with null | Job type. For point product use. |
| instance | varchar(60) | with null | Database instance to run against. Optional, for database related point products. |
| owner | varchar(50) | with null | Optional user id. For point product use (for RDBMS product, this would be the owner). |
| cred_value | varchar(60) | with null | Optional user password. Encryted / decrypted by API set and get. |
| connectstring | varchar(60) | with null | Optional DB connect string or name. |
| jobowner | varchar(50) | with null | For future use related to security (ie. only the owner of the job can change it). |
| accessmode | char(1) | with null | Locked flag; locked jobs require extra steps to delete and cannot be rerun. The job applications are responsible for setting and checking this flag. |
| can_be_resumed | smallint | with null | 1=Job can be resumed,
0=Job cannot be resumed.
This flag should be set by the client applications immediately after the job has been submitted. This flag will enable the "resume job" action on the specified job. |
| resume_requested | smallint | with null | 1=Job is resuming a previous run
0=Normal job
This flag will be set by the Browser/API when a "resume job" action is requested. It should be checked by the job application at run-time to see if the job to run is a "job resumation" or a new run. |
| run_to_resume | integer | with null | The job run to resume. This field can be used by a job application during a "job resumation" to determine which job run is being resumed. This field will be set by JAS when a "resume job" action is requested. |
| object | varchar(60) | with null | Optional object name. For point product use. |
| runstate | smallint | with null | 0=Waiting for next run 1=Current running |
| calendarid | char(30) | with null | Id of the optional calendar to use. |
| recurinterval | integer | with null | Recurrence interval.
0=No recurrences defined 1=Minutes 2 = Hourly 3 = Daily 4 = Weekly 5 = Monthly 6 = Yearly 7=Minutes after each hour This option is not compatible with the current functionality of Autosys. The "Minutes after each hour " option is used for compatibility with Autosys. |
| recurincrement | integer | with null | How often to run, depending on recurrence interval: "Every x minutes, every x days, every x months, etc." |
| everyweekday | smallint | with null | This flag states to run every day of the week (RecurInterval = Daily). If this is set and RecurInterval = Daily, RecurIncremet is ignored. |
| days_of_week | char(7) | with null | Zero padded array. Flags to indicate which day or days of the week to run (1 = Sunday, 7 = Saturday) (RecurInterval = Weekly) |
| dayofmonthflags | char(31) | with null | Zero padded array. Flag to indicate which day or days of the month to run (1 to 31) (RecurInterval = Monthly) |
| lastdayofmonth | smallint | with null | If true, run on the last day of the month(s) (RecurInterval = Monthly or Yearly). The job will run on the last day of the month regardless of which actual day the end of the month falls on (28, 29, 30, or 31). Can be used with or without the DayOfMonthFlags. If set, this takes precedence over the DayOfMonthFlags (ie. the job flag for November 30 is off and this is on, the job will run on November 30). |
| yearmonth | smallint | with null | Month to run (1-12) for yeary interval (RecurInterval = Yearly) |
| timeofdayhour | smallint | with null | Hour of day (0-23) to run. |
| timeofdayminute | smallint | with null | Minute of hour (0-59) to run. |
| start_times | char(60) | with null | "Minutes after each hour" flags. Zero-padded flags - one for each minute of the hour. This is used to emulate Autosys' "run at x minutes after each hour" behavior. Each flag, when on, signifies the job should run at that minute after EVERY hour after the the first run (determined by next_start). |
| cookies | integer | with null | Cookies is used to protect data from being updated/changed by the user not thru. LES (ex. Manually) |
| n_preemptretries | integer | with null | Number of contiguous retry attempts to accept before labeling the run as failed. This number is the maximum value RETRYCOUNT can have. |
Product Name: Unicenter Database Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| joid | mitjas_jobparms | joid |
| joid | mitjas_jobhist | joid |