os_scheduled_jobs

27 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
os_scheduled_job_runs.SCHEDULED_JOB_ID FK_OS_SCHEDULED_RUN_JOB_IDR
os_scheduled_job_shared_users.SCHEDULED_JOB_ID FK_OS_SCHEDULED_JOB_SU_JOBR
os_scheduled_jobs_notif_rcpts.SCHEDULED_JOB_ID FK_OS_SCHEDULED_JOB_RECIPIENTSR
NAME VARCHAR 255 null
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_OS_SCHEDULED_JOB_CREATED_BYR
START_DATE TIMESTAMP 19 null
END_DATE TIMESTAMP 19 √ null
SCHEDULED_MINUTE BIGINT 19 null
SCHEDULED_HOUR BIGINT 19 √ null
SCHEDULED_DAY_OF_WEEK VARCHAR 16 √ null
SCHEDULED_DAY_OF_MONTH BIGINT 19 √ null
ACTIVITY_STATUS VARCHAR 16 null
REPEAT_SCHEDULE VARCHAR 16 null
TYPE VARCHAR 16 null
COMMAND VARCHAR 255 √ null
TASK_IMPL_FQN VARCHAR 255 √ null
RT_ARGS_PROVIDED BIT 1 √ null
RT_ARGS_HELP_TEXT VARCHAR 255 √ null
HOURLY_INTERVAL MEDIUMINT 7 √ 1
MINUTELY_INTERVAL MEDIUMINT 7 √ 1
QUERY_ID BIGINT 19 √ null
catissue_saved_queries.IDENTIFIER FK_SCHED_QUERY_IDR
RUN_AS_USER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK_SCHED_RUN_USER_IDR
FIXED_ARGS TEXT 65535 √ null
RUN_BY_NODE VARCHAR 32 √ none

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_OS_SCHEDULED_JOB_CREATED_BY Performance Asc CREATED_BY
FK_SCHED_QUERY_ID Performance Asc QUERY_ID
FK_SCHED_RUN_USER_ID Performance Asc RUN_AS_USER_ID
NAME Must be unique Asc NAME

Relationships

Close relationships within degrees of separation