View netapp_model_view.job_schedule Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19
uuid varchar 512 The uuid of the job schedule.
resourceKey varchar 512
name varchar 255 The name of the job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-name
clusterId bigint 19
description varchar 255  √  null The description of the job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-description
scheduleType enum 10  √  null The type of job schedule. ZAPIs: job-schedule-iter job-schedule-info job-schedule-type.
scheduleTypeRaw varchar 255  √  null
cronDayOfMonth varchar 255  √  null The day(s) of the month when the job should be run. ZAPIs: job-schedule-cron-get-iter job-schedule-cron-info job-schedule-cron-day.
cronDayOfWeek varchar 255  √  null The day(s) in the week when the job should be run. ZAPIs: job-schedule-cron-get-iter job-schedule-cron-info job-schedule-cron-day-of-week
cronHour varchar 255  √  null The hour(s) of the day when the job should be run. ZAPIs: job-schedule-cron-get-iter job-schedule-cron-info job-schedule-cron-hour
cronMinute varchar 255  √  null The minute(s) of each hour when the job should be run. ZAPIs: job-schedule-cron-get-iter job-schedule-cron-info job-schedule-cron-minute
cronMonth varchar 255  √  null The month(s) when the job should be run. ZAPIs: job-schedule-cron-get-iter job-schedule-cron-info job-schedule-cron-month.
intervalDays int 10  √  null The number of days between jobs. ZAPIs: job-schedule-internval-get-iter job-schedule-interval-info job-schedule-interval-days
intervalHours int 10  √  null The number of hours between jobs. ZAPIs: job-schedule-internval-get-iter job-schedule-interval-info job-schedule-interval-hours
intervalMinutes int 10  √  null The number of minutes between jobs ZAPIs: job-schedule-internval-get-iter job-schedule-interval-info job-schedule-interval-minutes
intervalSeconds int 10  √  null The number of seconds between jobs. ZAPIs: job-schedule-internval-get-iter job-schedule-interval-info job-schedule-interval-seconds
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`job_schedule`.`objid` AS `objid`,`netapp_model`.`job_schedule`.`uuid` AS `uuid`,`netapp_model`.`job_schedule`.`resourceKey` AS `resourceKey`,`netapp_model`.`job_schedule`.`name` AS `name`,`netapp_model`.`job_schedule`.`clusterId` AS `clusterId`,`netapp_model`.`job_schedule`.`description` AS `description`,`netapp_model`.`job_schedule`.`scheduleType` AS `scheduleType`,`netapp_model`.`job_schedule`.`scheduleTypeRaw` AS `scheduleTypeRaw`,`netapp_model`.`job_schedule`.`cronDayOfMonth` AS `cronDayOfMonth`,`netapp_model`.`job_schedule`.`cronDayOfWeek` AS `cronDayOfWeek`,`netapp_model`.`job_schedule`.`cronHour` AS `cronHour`,`netapp_model`.`job_schedule`.`cronMinute` AS `cronMinute`,`netapp_model`.`job_schedule`.`cronMonth` AS `cronMonth`,`netapp_model`.`job_schedule`.`intervalDays` AS `intervalDays`,`netapp_model`.`job_schedule`.`intervalHours` AS `intervalHours`,`netapp_model`.`job_schedule`.`intervalMinutes` AS `intervalMinutes`,`netapp_model`.`job_schedule`.`intervalSeconds` AS `intervalSeconds`,`netapp_model`.`job_schedule`.`createtime` AS `createTime`,`netapp_model`.`job_schedule`.`updatetime` AS `updateTime` from `netapp_model`.`job_schedule` where (`netapp_model`.`job_schedule`.`objState` = 'LIVE')