openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/GET_CCMS_JOB_MSQ:
    post:
      tags:
      - SFMSS_JOBS
      summary: MS SQL server function to get the list of SAP CCMS planned task
      operationId: /rfc/GET_CCMS_JOB_MSQ
      requestBody:
        content:
          application/json:
            schema:
              properties:
                CON_NAME:
                  type: string
                  default: DEFAULT
                  maxLength: 30
                  description: Logical name for a database connection
                NUM_OF_DAYS:
                  type: integer
                  format: int32
                  default: 30
                  description: MS SQL server - run time limit for dbcc commands
                SCHEMA:
                  type: string
                  default: ''
                  maxLength: 128
                  description: Schema name
                TASKLIST:
                  type: array
                  items:
                    type: object
                    properties:
                      JOB_NAME:
                        type: string
                        maxLength: 100
                        description: MS SQl server - name of the job
                      OWNER:
                        type: string
                        maxLength: 30
                        description: Database user name/ Owner of sql agent job
                      DBNAME:
                        type: string
                        maxLength: 128
                        description: Database name
                      JOBTYPE:
                        type: string
                        maxLength: 60
                        description: MS SQL server - Name of the subsystem used for job execution
                      COMMAND:
                        type: string
                        maxLength: 520
                        description: MS SQL server - command executed by the subsytem
                      RUNDATE:
                        type: string
                        format: date
                        description: MS SQL server - the date to begin executing the job
                      RUNTIME:
                        type: string
                        maxLength: 6
                        description: MS SQL server - the time to start executing the server job
                      RUNSTATUS:
                        type: integer
                        format: int32
                        description: MS SQL server - the status of the job's execution
                      LSTRUNDATE:
                        type: string
                        format: date
                        description: Sql agent job - Last run Date
                      LSTRUNTIME:
                        type: string
                        maxLength: 6
                        description: Agent job's last run time
                      NEXTRUNTM:
                        type: string
                        maxLength: 6
                        description: SQL Agent Job's Next Run Time
                      NEXTRUNDT:
                        type: string
                        format: date
                        description: Sql agent job - Next run Date
                      JOBID:
                        type: string
                        format: byte
                        description: MS SQL server job id
                      ENABLED:
                        type: integer
                        format: int32
                        description: MS SQL server - job enable status for execution
                      STATUSDESC:
                        type: string
                        maxLength: 25
                        description: Sql Agent Job status description
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  TASKLIST:
                    type: array
                    items:
                      type: object
                      properties:
                        JOB_NAME:
                          type: string
                          maxLength: 100
                          description: MS SQl server - name of the job
                        OWNER:
                          type: string
                          maxLength: 30
                          description: Database user name/ Owner of sql agent job
                        DBNAME:
                          type: string
                          maxLength: 128
                          description: Database name
                        JOBTYPE:
                          type: string
                          maxLength: 60
                          description: MS SQL server - Name of the subsystem used for job execution
                        COMMAND:
                          type: string
                          maxLength: 520
                          description: MS SQL server - command executed by the subsytem
                        RUNDATE:
                          type: string
                          format: date
                          description: MS SQL server - the date to begin executing the job
                        RUNTIME:
                          type: string
                          maxLength: 6
                          description: MS SQL server - the time to start executing the server job
                        RUNSTATUS:
                          type: integer
                          format: int32
                          description: MS SQL server - the status of the job's execution
                        LSTRUNDATE:
                          type: string
                          format: date
                          description: Sql agent job - Last run Date
                        LSTRUNTIME:
                          type: string
                          maxLength: 6
                          description: Agent job's last run time
                        NEXTRUNTM:
                          type: string
                          maxLength: 6
                          description: SQL Agent Job's Next Run Time
                        NEXTRUNDT:
                          type: string
                          format: date
                          description: Sql agent job - Next run Date
                        JOBID:
                          type: string
                          format: byte
                          description: MS SQL server job id
                        ENABLED:
                          type: integer
                          format: int32
                          description: MS SQL server - job enable status for execution
                        STATUSDESC:
                          type: string
                          maxLength: 25
                          description: Sql Agent Job status description
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
