View ocum.jobreportview | Generated by SchemaSpy |
View Definition:
select `ocum`.`job`.`id` AS `id`,`ocum`.`job`.`jobType` AS `jobType`,`ocum`.`job`.`name` AS `name`,(case `ocum`.`job`.`status` when 'PARTIALLY_SUCCEEDED' then 2 when 'FAILED' then 3 else 0 end) AS `status`,(case `ocum`.`job`.`status` when 'RUNNING' then 'running' when 'ABORTING' then 'aborting' when 'ABORTED' then 'aborted' else 'completed' end) AS `state`,`ocum`.`job`.`submittedTimestamp` AS `submittedTimestamp`,`ocum`.`job`.`completedTimestamp` AS `completedTimestamp` from `ocum`.`job`
Possibly Referenced Tables/Views: