DANA
  1. jobmanager
DANA
  • DS迭代
    • DS5.6
      • jobmanager
        • 列举任务
          POST
        • 指标卡数据
          POST
      • 元数据-元数据开发-分层管理
        • 列举分层
      • 元数据-元数据开发-编目管理
        • 列举文件夹
        • 删除文件夹
        • 新增/编辑文件夹
      • 元数据-元数据开发-表管理
        • 表模型管理表详情
        • 表模型管理列举表信息
      • 元数据-规范中心-标准管理
        • 列举编目
        • 列举标准
      • 元数据-规范中心-脱敏规则
        • 列举脱敏规则
      • 元数据-敏感管理
        • 敏感等级-列举
        • 敏感识别规则列举
      • 任务运维-实时运维
        • 4.6实时任务运维-实时任务列表
      • 任务运维-周期运维-周期作业
        • 列举周期作业
      • 数据资产-资产概览
        • 获取分层数据总览
      • 数据资产-资产中心
        • 列举文件夹
        • 资产中心列举表v2
      • 数据资产-问题数据
        • 模糊搜索问题数据表信息。
      • 数据共享-发布管理-服务监控
        • 列举服务监控列表
      • 数据服务-服务管理
        • 服务列举接口
      • 文件夹管理
        • 文件夹列举
  1. jobmanager

列举任务

POST
/dodox/job/list

请求参数

Header 参数
Content-Type
string 
必需
示例值:
application/x-www-form-urlencoded
Body 参数application/json
page
integer 
必需
perpage
integer 
必需
userid
string 
必需
jobid
string 
必需
record_status
string 
必需
record_rangetime
object 
必需
to
string 
必需
from
string 
必需
sorttype
integer 
排序类型,默认为2
必需
sortorder
integer 
排序方式,默认为1
必需
示例
{
  "page": 1,
  "perpage": 15,
  "userid": "",
  "jobid": "",
  "record_status": "",
  "record_rangetime": {
    "to": "",
    "from": ""
  },
  "sorttype": 2,
  "sortorder": 1
}

返回响应

🟢200成功
application/json
Body
code
integer 
必需
result
array [object {62}] 
必需
id
string 
任务id
必需
name
string 
任务名称
必需
exectimes
integer 
执行次数
必需
tasktype
string 
任务类型
必需
subtasktype
integer 
子任务类型
必需
subjob
array [object {25}] 
子任务信息
必需
crontab
string 
定时策略
必需
crondetail
string 
定时策略详情
必需
distributionhour
array[integer] | null 
必需
scheduletype
integer 
执行策略
必需
scheduledetail
string 
执行策略详情
必需
label
object 
必需
feedback
object 
必需
autoassign
boolean 
必需
status
string 
状态
必需
successcount
integer 
成功次数
必需
failcount
integer 
失败次数
必需
avgtime
integer 
平均执行时间
必需
lastrunnode
string 
上次执行节点
必需
lastrunstatus
string 
上次执行状态
必需
undercron
string 
必需
createtime
string 
创建时间
必需
lastruntime
string 
上次执行时间
必需
lastsuccesstime
string 
上次成功执行时间
必需
onlinetime
string 
上线时间
必需
nextruntime
string 
计划下次执行时间
必需
userid
string 
必需
username
string 
必需
starttime
string 
开始执行时间
必需
preid
array[string]
必需
prejob
string 
必需
cidtimevars
null 
必需
istimeout
boolean 
执行是否超时
必需
timeoutflag
boolean 
必需
tdcload
string 
必需
projectid
string 
必需
globalvars
object 
必需
customtimevars
null 
必需
customconstantvars
null 
必需
datastrategy
string 
必需
accincrestatus
object 
必需
comboid
string 
必需
comboname
string 
必需
offline
boolean 
必需
rule
null 
必需
jobtype
integer 
必需
exportable
integer 
必需
layout
string 
必需
combos
array [object {5}]  | null 
必需
belongmateria
string 
必需
isban
boolean 
必需
isstartnow
boolean 
必需
count
integer 
必需
inittime
string 
必需
goingoffline
string 
必需
isrecorderr
boolean 
必需
isbatchtask
boolean 
必需
firststarttime
string 
必需
pretips
string 
必需
lastfailtime_v2
string 
必需
jobversion
integer 
必需
description
string 
必需
total
integer 
必需
示例
{
  "code": 200,
  "result": [
    {
      "id": "bad26d3c05525acca9d6e89593b36cb5",
      "name": "xm",
      "exectimes": -1,
      "tasktype": "datax",
      "subtasktype": 1,
      "subjob": [
        {
          "subid": 1,
          "name": "xm",
          "description": "",
          "cmd": "python /var/dana/dodox/filemanager/file/danastudio-submit/admin_user_test_xm3ax1.datax/admin_user_test_xm3ax1.datax",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "admin_user_test_xm3ax1.datax",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 3,
          "isretry": true,
          "retryinterval": 1,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "xm",
          "engineid": "AY9SCYUTmDZLs14-C5qT",
          "analyzesql": "ANALYZE \"xm\".\"fenqu\"",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AYj2-rcgIaEuChJaIKcV",
        "id": "admin_user_test_xm3ax1.datax",
        "langtype": "datax",
        "module": "datax",
        "name": "xm",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/access/down -d '{\"ids\":[\"admin_user_test_xm3ax1.datax\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 1,
      "failcount": 0,
      "avgtime": 16,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-05-07 15:59:00",
      "lastruntime": "2024-05-07 15:59:24",
      "lastsuccesstime": "2024-05-07 15:59:24",
      "onlinetime": "2024-05-07 15:59:00",
      "nextruntime": "--",
      "userid": "AYVNJiUFeuoGNqnKLfSj",
      "username": "dev_cqq",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "datastrategy": "覆盖存储表数据",
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 1,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-05-07 15:59:00",
      "goingoffline": "",
      "isrecorderr": true,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "24cada1839d58bc02eb4fe02f514afe2",
      "name": "合同主题表采集",
      "tasktype": "datax",
      "subtasktype": 1,
      "subjob": [
        {
          "subid": 1,
          "name": "合同主题表采集",
          "description": "",
          "cmd": "/var/dana/dodox/filemanager/file/danastudio-submit/admin_user_经营分析CY_合同主题表采集9VwC.datax/admin_user_经营分析CY_合同主题表采集9VwC.datax",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "admin_user_经营分析CY_合同主题表采集9VwC.datax",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 3,
          "isretry": true,
          "retryinterval": 3,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "dw_caiyu",
          "engineid": "AYU4gzyueuoGNqnKLWxL",
          "analyzesql": "ANALYZE TABLE `htztb20240328` COMPUTE STATISTICS",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AY6DHHwENfQNknqHGrY6",
        "id": "admin_user_经营分析CY_合同主题表采集9VwC.datax",
        "langtype": "datax",
        "module": "datax",
        "name": "合同主题表采集",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/access/down -d '{\"ids\":[\"admin_user_经营分析CY_合同主题表采集9VwC.datax\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 0,
      "failcount": 1,
      "avgtime": 208,
      "lastrunnode": "",
      "lastrunstatus": "FAIL",
      "undercron": "false",
      "createtime": "2024-03-28 11:39:56",
      "lastruntime": "2024-03-29 18:33:36",
      "lastfailtime_v2": "2024-03-29 18:33:36",
      "onlinetime": "2024-05-07 11:25:18",
      "nextruntime": "--",
      "userid": "AYVNJiUFeuoGNqnKLfSj",
      "username": "dev_cqq",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "datastrategy": "覆盖存储表数据",
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 1,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-05-07 11:25:18",
      "goingoffline": "",
      "isrecorderr": true,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "8b61f7c695c759855d55d413335c1b92",
      "name": "test11",
      "exectimes": -1,
      "tasktype": "dag",
      "subtasktype": 0,
      "subjob": [
        {
          "subid": 31262816,
          "name": "test",
          "description": "",
          "cmd": "python /etc/danastudio/mg_sql.py exec -e AYU4gzyueuoGNqnKLWxL -d pdys_basedb  -f /var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92/cYN53TLM993 ",
          "pre": [],
          "post": [
            41121124
          ],
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "cYN53TLM993",
          "ctype": "sql",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 6,
          "comboid": "input",
          "comboname": "数据接入",
          "xtype": "",
          "sourcedb": "pdys_basedb",
          "engineid": "AYU4gzyueuoGNqnKLWxL",
          "analyzesql": "",
          "extractdbid": ""
        },
        {
          "subid": 41121124,
          "name": "test1",
          "description": "",
          "cmd": "curl -XGET 'http://127.0.0.1:21612/danastudio/ants/dataprocess/checkudf:cKY7PI3UIV0' -d{}  && python /etc/danastudio/mg_sql.py exec -e AYU4gzyueuoGNqnKLWxL -d pdys_basedb  -f /var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92/cKY7PI3UIV0 ",
          "pre": [
            31262816
          ],
          "post": [
            78729318
          ],
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "cKY7PI3UIV0",
          "ctype": "sql",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 7,
          "comboid": "exam",
          "comboname": "质量探查",
          "xtype": "",
          "sourcedb": "pdys_basedb",
          "engineid": "AYU4gzyueuoGNqnKLWxL",
          "analyzesql": "",
          "extractdbid": ""
        },
        {
          "subid": 78729318,
          "name": "落地",
          "description": "",
          "cmd": "python /opt/dana/datax/bin/datax.py /var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92/c06H30Z49AA ",
          "pre": [
            41121124
          ],
          "post": [],
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "c06H30Z49AA",
          "ctype": "sql",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 10,
          "comboid": "output",
          "comboname": "数据落地",
          "xtype": "",
          "sourcedb": "dw_caiyu",
          "engineid": "AYU4gzyueuoGNqnKLWxL",
          "analyzesql": "ANALYZE TABLE `htztb20240328` COMPUTE STATISTICS",
          "extractdbid": ""
        }
      ],
      "crontab": "0 0 * * *",
      "crondetail": "每天 00:00",
      "distributionhour": [
        0
      ],
      "scheduletype": 1,
      "scheduledetail": "00:00",
      "label": {
        "concat": [],
        "deletetime": "",
        "dirid": "AY5BesnjGh6e4pDkuT08",
        "langtype": "dag",
        "module": "workflow",
        "star": false,
        "subjob": [
          {
            "analyzesql": "",
            "cid": "cYN53TLM993",
            "cmd": "python /etc/danastudio/mg_sql.py exec -e AYU4gzyueuoGNqnKLWxL -d pdys_basedb  -f /var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92/cYN53TLM993 ",
            "column": 0,
            "comboid": "input",
            "comboname": "数据接入",
            "ctype": "sql",
            "description": "",
            "engineid": "AYU4gzyueuoGNqnKLWxL",
            "enginename": "hive",
            "envtag": null,
            "fail_post": null,
            "flag": false,
            "inputtb": "",
            "isown": false,
            "isretry": false,
            "mattaskid": "",
            "module": 6,
            "name": "test",
            "post": [
              41121124
            ],
            "pre": [],
            "retryinterval": 0,
            "retrynum": 0,
            "row": 0,
            "sourcedb": "pdys_basedb",
            "status": true,
            "subid": 31262816,
            "success_post": null,
            "symbol": "PROCESS",
            "tag": null,
            "tbname": "cYN53TLM993",
            "unsubmitcmddatax": "",
            "x": 507,
            "xtype": "",
            "y": 201
          },
          {
            "analyzesql": "",
            "cid": "cKY7PI3UIV0",
            "cmd": "curl -XGET 'http://127.0.0.1:21612/danastudio/ants/dataprocess/checkudf:cKY7PI3UIV0' -d{}  && python /etc/danastudio/mg_sql.py exec -e AYU4gzyueuoGNqnKLWxL -d pdys_basedb  -f /var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92/cKY7PI3UIV0 ",
            "column": 0,
            "comboid": "exam",
            "comboname": "质量探查",
            "ctype": "sql",
            "description": "",
            "engineid": "AYU4gzyueuoGNqnKLWxL",
            "enginename": "hive",
            "envtag": null,
            "fail_post": null,
            "flag": false,
            "inputtb": "",
            "isown": false,
            "isretry": false,
            "mattaskid": "",
            "module": 7,
            "name": "test1",
            "post": [
              78729318
            ],
            "pre": [
              31262816
            ],
            "retryinterval": 0,
            "retrynum": 0,
            "row": 0,
            "sourcedb": "pdys_basedb",
            "status": true,
            "subid": 41121124,
            "success_post": null,
            "symbol": "PROCESS",
            "tag": null,
            "tbname": "cKY7PI3UIV0",
            "unsubmitcmddatax": "",
            "x": 849,
            "xtype": "",
            "y": 212
          },
          {
            "analyzesql": "ANALYZE TABLE `htztb20240328` COMPUTE STATISTICS",
            "cid": "c06H30Z49AA",
            "cmd": "python /opt/dana/datax/bin/datax.py /var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92/c06H30Z49AA ",
            "column": 0,
            "comboid": "output",
            "comboname": "数据落地",
            "ctype": "sql",
            "description": "",
            "engineid": "AYU4gzyueuoGNqnKLWxL",
            "enginename": "testhive",
            "envtag": null,
            "fail_post": null,
            "flag": false,
            "inputtb": "",
            "isown": false,
            "isretry": false,
            "mattaskid": "",
            "module": 10,
            "name": "落地",
            "post": [],
            "pre": [
              41121124
            ],
            "retryinterval": 0,
            "retrynum": 0,
            "row": 0,
            "sourcedb": "dw_caiyu",
            "status": true,
            "subid": 78729318,
            "success_post": null,
            "symbol": "PROCESS",
            "tag": null,
            "tbname": "htztb20240328",
            "unsubmitcmddatax": "",
            "x": 1062,
            "xtype": "",
            "y": 462
          }
        ],
        "submitinfo": {
          "assignnode": "",
          "exectimes": -1,
          "scheduledetail": "00:00",
          "scheduletype": 1,
          "submitpath": "/var/dana/dodox/filemanager/file/danastudio-submit/8b61f7c695c759855d55d413335c1b92"
        },
        "submitted": true,
        "tags": null,
        "toptime": "",
        "trash": false,
        "updatetime": "2024-04-28 17:37:01"
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/workflow/down -d '{\"ids\":[\"8b61f7c695c759855d55d413335c1b92\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 11,
      "failcount": 1,
      "avgtime": 206,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2024-04-09 17:32:22",
      "lastruntime": "2024-05-08 00:03:45",
      "lastsuccesstime": "2024-05-08 00:03:45",
      "lastfailtime_v2": "2024-05-04 00:01:09",
      "onlinetime": "2024-04-28 17:45:07",
      "nextruntime": "2024-05-09 00:00:00",
      "userid": "AYVNJiUFeuoGNqnKLfSj",
      "username": "dev_cqq",
      "starttime": "",
      "preid": null,
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 0,
      "exportable": 0,
      "jobversion": 1,
      "layout": "h",
      "combos": [
        {
          "id": "input",
          "label": "数据接入",
          "children": [
            "31262816"
          ],
          "x": 607,
          "y": 216
        },
        {
          "id": "exam",
          "label": "质量探查",
          "children": [
            "41121124"
          ],
          "x": 949,
          "y": 227
        },
        {
          "id": "output",
          "label": "数据落地",
          "children": [
            "78729318"
          ],
          "x": 1162,
          "y": 477
        },
        {
          "id": "safe_identify",
          "label": "敏感数据识别",
          "children": [],
          "x": 511,
          "y": 492
        },
        {
          "id": "safe_datasafe",
          "label": "数据安全",
          "children": [],
          "x": 572,
          "y": 335
        }
      ],
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-04-28 17:45:07",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "ad5d3696f5489cc8c3d2f328ad3ef266",
      "name": "统计运行管理页面指标",
      "exectimes": -1,
      "tasktype": "dag",
      "subtasktype": 0,
      "subjob": [
        {
          "subid": 33168712,
          "name": "统计运行管理指标",
          "description": "",
          "cmd": "/bin/bash /var/dana/dodox/filemanager/file/danastudio-submit/ad5d3696f5489cc8c3d2f328ad3ef266/s336920H7SQ",
          "pre": [],
          "post": [],
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "s336920H7SQ",
          "ctype": "shell",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "script",
          "comboname": "自定义加工",
          "xtype": "",
          "sourcedb": "pdys_basedb",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "0 0 * * *",
      "crondetail": "每天 00:00",
      "distributionhour": [
        0
      ],
      "scheduletype": 1,
      "scheduledetail": "00:00",
      "label": {
        "concat": null,
        "deletetime": "",
        "dirid": "AYhHoUJ--I9vQlLu9PfY",
        "langtype": "dag",
        "module": "workflow",
        "star": false,
        "subjob": [
          {
            "analyzesql": "",
            "cid": "s336920H7SQ",
            "cmd": "/bin/bash /var/dana/dodox/filemanager/file/danastudio-submit/ad5d3696f5489cc8c3d2f328ad3ef266/s336920H7SQ",
            "column": 0,
            "comboid": "script",
            "comboname": "自定义加工",
            "ctype": "shell",
            "description": "",
            "engineid": "",
            "enginename": "",
            "envtag": null,
            "fail_post": null,
            "flag": false,
            "inputtb": "",
            "isown": false,
            "isretry": false,
            "mattaskid": "",
            "module": 0,
            "name": "统计运行管理指标",
            "post": [],
            "pre": [],
            "retryinterval": 0,
            "retrynum": 0,
            "row": 0,
            "sourcedb": "pdys_basedb",
            "status": true,
            "subid": 33168712,
            "success_post": null,
            "symbol": "PROCESS",
            "tag": null,
            "tbname": "s336920H7SQ",
            "unsubmitcmddatax": "",
            "x": 431,
            "xtype": "",
            "y": 290
          }
        ],
        "submitinfo": {
          "assignnode": "",
          "exectimes": -1,
          "scheduledetail": "00:00",
          "scheduletype": 1,
          "submitpath": "/var/dana/dodox/filemanager/file/danastudio-submit/ad5d3696f5489cc8c3d2f328ad3ef266"
        },
        "submitted": true,
        "tags": null,
        "toptime": "",
        "trash": false,
        "updatetime": "2023-05-23 16:06:20"
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/workflow/down -d '{\"ids\":[\"ad5d3696f5489cc8c3d2f328ad3ef266\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 64,
      "failcount": 1,
      "avgtime": 399,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2023-05-23 16:02:10",
      "lastruntime": "2024-05-08 00:05:16",
      "lastsuccesstime": "2024-05-08 00:05:16",
      "lastfailtime_v2": "2024-04-18 16:45:31",
      "onlinetime": "2024-04-18 16:46:07",
      "nextruntime": "2024-05-09 00:00:00",
      "userid": "AYVNJiUFeuoGNqnKLfSj",
      "username": "dev_cqq",
      "starttime": "",
      "preid": null,
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 0,
      "exportable": 0,
      "jobversion": 1,
      "layout": "h",
      "combos": [
        {
          "id": "script",
          "label": "自定义加工",
          "children": [
            "33168712"
          ],
          "x": 531,
          "y": 305
        }
      ],
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-04-18 16:46:07",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "a36088d551cb94b4cdab212968c4efda",
      "name": "测试",
      "exectimes": -1,
      "tasktype": "dag",
      "subtasktype": 0,
      "subjob": [
        {
          "subid": 18886899,
          "name": "test",
          "description": "",
          "cmd": "python /etc/danastudio/mg_sql.py exec -e AYU4gzyueuoGNqnKLWxL -d pdys_basedb  -f /var/dana/dodox/filemanager/file/danastudio-submit/a36088d551cb94b4cdab212968c4efda/c7Z0V33151E ",
          "pre": [],
          "post": [],
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "c7Z0V33151E",
          "ctype": "sql",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 6,
          "comboid": "input",
          "comboname": "数据接入",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "0 0 * * *",
      "crondetail": "每天 00:00",
      "distributionhour": [
        0
      ],
      "scheduletype": 1,
      "scheduledetail": "00:00",
      "label": {
        "concat": null,
        "deletetime": "",
        "dirid": "AY6Y486Mh4WaUvQWZKId",
        "langtype": "dag",
        "module": "workflow",
        "star": false,
        "subjob": [
          {
            "analyzesql": "",
            "cid": "c7Z0V33151E",
            "cmd": "python /etc/danastudio/mg_sql.py exec -e AYU4gzyueuoGNqnKLWxL -d pdys_basedb  -f /var/dana/dodox/filemanager/file/danastudio-submit/a36088d551cb94b4cdab212968c4efda/c7Z0V33151E ",
            "column": 0,
            "comboid": "input",
            "comboname": "数据接入",
            "ctype": "sql",
            "description": "",
            "engineid": "",
            "enginename": "",
            "envtag": null,
            "fail_post": null,
            "flag": false,
            "inputtb": "",
            "isown": false,
            "isretry": false,
            "mattaskid": "",
            "module": 6,
            "name": "test",
            "post": [],
            "pre": [],
            "retryinterval": 0,
            "retrynum": 0,
            "row": 0,
            "sourcedb": "",
            "status": false,
            "subid": 18886899,
            "success_post": null,
            "symbol": "PROCESS",
            "tag": null,
            "tbname": "",
            "unsubmitcmddatax": "",
            "x": 529,
            "xtype": "",
            "y": 265
          }
        ],
        "submitinfo": {
          "assignnode": "",
          "exectimes": -1,
          "scheduledetail": "00:00",
          "scheduletype": 1,
          "submitpath": "/var/dana/dodox/filemanager/file/danastudio-submit/a36088d551cb94b4cdab212968c4efda"
        },
        "submitted": true,
        "tags": null,
        "toptime": "",
        "trash": false,
        "updatetime": "2024-04-18 08:56:18"
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/workflow/down -d '{\"ids\":[\"a36088d551cb94b4cdab212968c4efda\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 18,
      "failcount": 2,
      "avgtime": 141,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2024-04-18 08:55:04",
      "lastruntime": "2024-05-08 00:01:35",
      "lastsuccesstime": "2024-05-08 00:01:35",
      "lastfailtime_v2": "2024-05-04 00:00:37",
      "onlinetime": "2024-04-18 08:56:37",
      "nextruntime": "2024-05-09 00:00:00",
      "userid": "AYVNJiUFeuoGNqnKLfSj",
      "username": "dev_cqq",
      "starttime": "",
      "preid": null,
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 0,
      "exportable": 0,
      "jobversion": 1,
      "layout": "h",
      "combos": [
        {
          "id": "input",
          "label": "数据接入",
          "children": [
            "18886899"
          ],
          "x": 348,
          "y": 150
        }
      ],
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-04-18 08:56:37",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "6b00d4040fe63ca5d490f556610c6d95",
      "name": "合同表测试采集",
      "exectimes": -1,
      "tasktype": "datax",
      "subtasktype": 1,
      "subjob": [
        {
          "subid": 1,
          "name": "合同表测试采集",
          "description": "",
          "cmd": "/var/dana/dodox/filemanager/file/danastudio-submit/admin_user_test_合同表测试采集10B6.datax/admin_user_test_合同表测试采集10B6.datax",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "admin_user_test_合同表测试采集10B6.datax",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 3,
          "isretry": true,
          "retryinterval": 1,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "test001",
          "engineid": "AYU4gzyueuoGNqnKLWxL",
          "analyzesql": "ANALYZE TABLE `htbcscj` COMPUTE STATISTICS",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AYj2-rcgIaEuChJaIKcV",
        "id": "admin_user_test_合同表测试采集10B6.datax",
        "langtype": "datax",
        "module": "datax",
        "name": "合同表测试采集",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/access/down -d '{\"ids\":[\"admin_user_test_合同表测试采集10B6.datax\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 4,
      "failcount": 0,
      "avgtime": 19,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-03-29 18:35:12",
      "lastruntime": "2024-04-18 16:43:54",
      "lastsuccesstime": "2024-04-18 16:43:54",
      "onlinetime": "2024-03-29 18:35:12",
      "nextruntime": "--",
      "userid": "AYVgyasXeuoGNqnKLoDx",
      "username": "spike1999",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "datastrategy": "覆盖存储表数据",
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 1,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-29 18:35:12",
      "goingoffline": "",
      "isrecorderr": true,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "b689dec6a94cfe86c0eddd4405965202",
      "name": "DANA实际销售额",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "DANA实际销售额",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZBF9R7F",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZBF9R7F",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AY6DXpY0NfQNknqHGrps",
        "id": "ZBF9R7F",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "DANA实际销售额",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZBF9R7F\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 3,
      "failcount": 0,
      "avgtime": 6,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-03-28 15:24:02",
      "lastruntime": "2024-04-18 16:43:40",
      "lastsuccesstime": "2024-04-18 16:43:40",
      "onlinetime": "2024-03-28 15:24:02",
      "nextruntime": "--",
      "userid": "AYVc-2hWeuoGNqnKLmVh",
      "username": "caiyu",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-28 15:24:02",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "d1b3d6d49bce272e8f0664cb54631d33",
      "name": "DANA按产品类型分布销售情况",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "DANA按产品类型分布销售情况",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZBNX8JL",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZBNX8JL",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AY6DXpY0NfQNknqHGrps",
        "id": "ZBNX8JL",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "DANA按产品类型分布销售情况",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZBNX8JL\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 2,
      "failcount": 0,
      "avgtime": 6,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-03-28 15:24:01",
      "lastruntime": "2024-04-18 16:43:41",
      "lastsuccesstime": "2024-04-18 16:43:41",
      "onlinetime": "2024-03-28 15:24:01",
      "nextruntime": "--",
      "userid": "AYVc-2hWeuoGNqnKLmVh",
      "username": "caiyu",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-28 15:24:01",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "de7c8ac48108187126a966995fdb5847",
      "name": "DANA年度业绩完成率",
      "description": "按照百分比计算DANA年度业绩完成率",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "DANA年度业绩完成率",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZB84Q56",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZB84Q56",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "0 0 * * *",
      "crondetail": "每天 00:00",
      "distributionhour": [
        0
      ],
      "scheduletype": 1,
      "scheduledetail": "00:00",
      "label": {
        "concat": [],
        "dirid": "AY6DXpY0NfQNknqHGrps",
        "id": "ZB84Q56",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "DANA年度业绩完成率",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZB84Q56\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 41,
      "failcount": 0,
      "avgtime": 6,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2024-03-28 15:23:59",
      "lastruntime": "2024-05-08 00:00:34",
      "lastsuccesstime": "2024-05-08 00:00:34",
      "onlinetime": "2024-03-28 15:23:59",
      "nextruntime": "2024-05-09 00:00:00",
      "userid": "AYVc-2hWeuoGNqnKLmVh",
      "username": "caiyu",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-28 15:23:59",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "c385518c87228265c44eeeb126db0ebd",
      "name": "涉及大数据事业部的总合同额",
      "description": "涉及大数据事业部的总合同额,除大数据事业部的产品和服务费用外,也包括外采、云计算等合同额",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "涉及大数据事业部的总合同额",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZB33ULX",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZB33ULX",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AY6DXpY0NfQNknqHGrps",
        "id": "ZB33ULX",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "涉及大数据事业部的总合同额",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZB33ULX\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 3,
      "failcount": 0,
      "avgtime": 6,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-03-28 14:23:57",
      "lastruntime": "2024-04-18 16:47:15",
      "lastsuccesstime": "2024-04-18 16:47:15",
      "onlinetime": "2024-03-28 14:23:57",
      "nextruntime": "--",
      "userid": "AYVc-2hWeuoGNqnKLmVh",
      "username": "caiyu",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-28 14:23:57",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "d17f3ffb0c030f08c1b6ba0d83006a4c",
      "name": "按产品类型的合同额",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "按产品类型的合同额",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZB1B97B",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZB1B97B",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AY6DXpY0NfQNknqHGrps",
        "id": "ZB1B97B",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "按产品类型的合同额",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZB1B97B\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 1,
      "failcount": 0,
      "avgtime": 7,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-03-28 14:17:41",
      "lastruntime": "2024-03-28 14:18:03",
      "lastsuccesstime": "2024-03-28 14:18:03",
      "onlinetime": "2024-03-28 14:17:41",
      "nextruntime": "--",
      "userid": "AYVc-2hWeuoGNqnKLmVh",
      "username": "caiyu",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-28 14:17:41",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "4e705b67bbfababd748d3296679919c1",
      "name": "合同主体表专题层采集",
      "tasktype": "datax",
      "subtasktype": 1,
      "subjob": [
        {
          "subid": 1,
          "name": "合同主体表专题层采集",
          "description": "",
          "cmd": "python /var/dana/dodox/filemanager/file/danastudio-submit/admin_user_经营分析CY_合同主体表专题层采集V509.datax/admin_user_经营分析CY_合同主体表专题层采集V509.datax",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "admin_user_经营分析CY_合同主体表专题层采集V509.datax",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "dws",
          "engineid": "stork_dn71",
          "analyzesql": "ANALYZE \"dwsschema\".\"dwd_htztb\"",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AY6DHHwENfQNknqHGrY6",
        "id": "admin_user_经营分析CY_合同主体表专题层采集V509.datax",
        "langtype": "datax",
        "module": "datax",
        "name": "合同主体表专题层采集",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/access/down -d '{\"ids\":[\"admin_user_经营分析CY_合同主体表专题层采集V509.datax\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 5,
      "failcount": 0,
      "avgtime": 16,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "false",
      "createtime": "2024-03-28 11:54:13",
      "lastruntime": "2024-03-28 13:23:09",
      "lastsuccesstime": "2024-03-28 13:23:09",
      "onlinetime": "2024-03-28 13:22:43",
      "nextruntime": "--",
      "userid": "AYVc-2hWeuoGNqnKLmVh",
      "username": "caiyu",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "datastrategy": "覆盖存储表数据",
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 1,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-28 13:22:43",
      "goingoffline": "",
      "isrecorderr": true,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "a0c6eec55b3714a523a3e46e2f653985",
      "name": "在校本科人数",
      "description": "统计在校本科生人数",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "在校本科人数",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZBSAJKQ",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZBSAJKQ",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "0 0 * * *",
      "crondetail": "每天 00:00",
      "distributionhour": [
        0
      ],
      "scheduletype": 1,
      "scheduledetail": "00:00",
      "label": {
        "concat": [],
        "dirid": "AY00-ztvI-IiMZr2dlBE",
        "id": "ZBSAJKQ",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "在校本科人数",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZBSAJKQ\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 22,
      "failcount": 27,
      "avgtime": 798,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2024-03-20 10:31:27",
      "lastruntime": "2024-05-08 00:01:01",
      "lastsuccesstime": "2024-05-08 00:01:01",
      "lastfailtime_v2": "2024-05-04 00:00:16",
      "onlinetime": "2024-03-20 10:31:27",
      "nextruntime": "2024-05-09 00:00:00",
      "userid": "AYf3Ex-u-I9vQlLu8m5I",
      "username": "dev_zhao",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-20 10:31:27",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "df071c4aeac8f96878f50add8fcda386",
      "name": "教职工入职量统计",
      "exectimes": -1,
      "tasktype": "dataMetrics",
      "subtasktype": 8,
      "subjob": [
        {
          "subid": 1,
          "name": "教职工入职量统计",
          "description": "",
          "cmd": "python /etc/danastudio/sql.py ZB63PZ9",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "ZB63PZ9",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 0,
          "isretry": false,
          "retryinterval": 0,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "",
          "engineid": "",
          "analyzesql": "",
          "extractdbid": ""
        }
      ],
      "crontab": "0 0 * * *",
      "crondetail": "每天 00:00",
      "distributionhour": [
        0
      ],
      "scheduletype": 1,
      "scheduledetail": "00:00",
      "label": {
        "concat": [],
        "dirid": "AY00-ztvI-IiMZr2dlBE",
        "id": "ZB63PZ9",
        "langtype": "dataMetrics",
        "module": "dataMetrics",
        "name": "教职工入职量统计",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/metrics/down -d '{\"zbids\":[\"ZB63PZ9\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 31,
      "failcount": 27,
      "avgtime": 58,
      "lastrunnode": "192.168.70.71",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2024-03-12 16:58:48",
      "lastruntime": "2024-05-08 00:01:09",
      "lastsuccesstime": "2024-05-08 00:01:09",
      "lastfailtime_v2": "2024-05-04 00:01:05",
      "onlinetime": "2024-03-12 17:11:46",
      "nextruntime": "2024-05-09 00:00:00",
      "userid": "AYVNKigzeuoGNqnKLfTP",
      "username": "dev_ct",
      "starttime": "",
      "preid": [],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 8,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-03-12 17:11:46",
      "goingoffline": "",
      "isrecorderr": false,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": ""
    },
    {
      "id": "546e46c88cb4e5cef792222587799800",
      "name": "一卡通采集",
      "tasktype": "datax",
      "subtasktype": 1,
      "subjob": [
        {
          "subid": 1,
          "name": "一卡通采集",
          "description": "",
          "cmd": "/var/dana/dodox/filemanager/file/danastudio-submit/admin_user_test_一卡通采集Y6KH.datax/admin_user_test_一卡通采集Y6KH.datax",
          "pre": null,
          "post": null,
          "symbol": "PROCESS",
          "success_post": null,
          "fail_post": null,
          "envtag": null,
          "cid": "admin_user_test_一卡通采集Y6KH.datax",
          "ctype": "",
          "cidtimevars": null,
          "isown": false,
          "retrynum": 3,
          "isretry": true,
          "retryinterval": 1,
          "module": 0,
          "comboid": "",
          "comboname": "",
          "xtype": "",
          "sourcedb": "ods",
          "engineid": "AYU5BvDTeuoGNqnKLW_O",
          "analyzesql": "ANALYZE TABLE `abc` COMPUTE STATISTICS",
          "extractdbid": ""
        }
      ],
      "crontab": "",
      "crondetail": "手动执行",
      "distributionhour": null,
      "scheduletype": 5,
      "scheduledetail": "",
      "label": {
        "concat": [],
        "dirid": "AYj2-rcgIaEuChJaIKcV",
        "id": "admin_user_test_一卡通采集Y6KH.datax",
        "langtype": "datax",
        "module": "datax",
        "name": "一卡通采集",
        "tags": null
      },
      "feedback": {
        "delete": "curl -XPOST 127.0.0.1:21612/danastudio/ants/access/down -d '{\"ids\":[\"admin_user_test_一卡通采集Y6KH.datax\"]}'"
      },
      "autoassign": true,
      "status": "WAITING",
      "successcount": 0,
      "failcount": 0,
      "avgtime": 56,
      "lastrunnode": "",
      "lastrunstatus": "SUCCESS",
      "undercron": "true",
      "createtime": "2024-02-03 10:23:13",
      "lastsuccesstime": "2024-02-18 00:07:22",
      "onlinetime": "2024-02-19 10:29:48",
      "nextruntime": "--",
      "userid": "AYVNKl_EeuoGNqnKLfTT",
      "username": "dev_zh",
      "starttime": "",
      "preid": [
        "9c0b51c91d74137185201941613536d2"
      ],
      "prejob": "",
      "cidtimevars": null,
      "istimeout": false,
      "timeoutflag": false,
      "tdcload": "",
      "projectid": "pdys",
      "globalvars": {
        "constantvars": null,
        "dynamicvars": null,
        "timevars": null,
        "crontype": ""
      },
      "customtimevars": null,
      "customconstantvars": null,
      "datastrategy": "覆盖存储表数据",
      "accincrestatus": {
        "iscreate": false,
        "issynchistory": false,
        "isdeletesoutb": false
      },
      "comboid": "",
      "comboname": "",
      "offline": false,
      "rule": null,
      "jobtype": 1,
      "exportable": 0,
      "layout": "",
      "combos": null,
      "belongmateria": "",
      "isban": false,
      "isstartnow": false,
      "count": 0,
      "inittime": "2024-02-19 10:29:48",
      "goingoffline": "",
      "isrecorderr": true,
      "isbatchtask": false,
      "firststarttime": "",
      "pretips": "前置任务未上线或未成功运行"
    }
  ],
  "total": 47
}
修改于 2024-05-08 06:48:42
下一页
指标卡数据
Built with