GET api/JobRequest

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of JobRequest
NameDescriptionTypeAdditional information
JobId

integer

None.

JobName

string

None.

CommandName

string

None.

SourceDatabase

string

None.

TargetDatabase

string

None.

Status

string

None.

Scheduleddate

date

None.

Active

boolean

None.

BackupRequired

boolean

None.

submittedDate

date

None.

BackupDatabaseCompleted

date

None.

RestoreDatabaseCompleted

date

None.

Processed

boolean

None.

Error

boolean

None.

CreateDate

date

None.

ModifiedDate

date

None.

DBTICKET

string

None.

SRCSQLSERVER

string

None.

DSTSQLSERVER

string

None.

OVERWRITEIFEXIST

boolean

None.

SCRUBNEWDATABASE

boolean

None.

GETNEWBACKUP

boolean

None.

SendEmail

boolean

None.

Response Formats

application/json, text/json

Sample:
[
  {
    "JobId": 1,
    "JobName": "sample string 2",
    "CommandName": "sample string 3",
    "SourceDatabase": "sample string 4",
    "TargetDatabase": "sample string 5",
    "Status": "sample string 6",
    "Scheduleddate": "2025-04-26T02:30:16.8632107-04:00",
    "Active": true,
    "BackupRequired": true,
    "submittedDate": "2025-04-26T02:30:16.8632107-04:00",
    "BackupDatabaseCompleted": "2025-04-26T02:30:16.8632107-04:00",
    "RestoreDatabaseCompleted": "2025-04-26T02:30:16.8632107-04:00",
    "Processed": true,
    "Error": true,
    "CreateDate": "2025-04-26T02:30:16.8632107-04:00",
    "ModifiedDate": "2025-04-26T02:30:16.8632107-04:00",
    "DBTICKET": "sample string 10",
    "SRCSQLSERVER": "sample string 11",
    "DSTSQLSERVER": "sample string 12",
    "OVERWRITEIFEXIST": true,
    "SCRUBNEWDATABASE": true,
    "GETNEWBACKUP": true,
    "SendEmail": true
  },
  {
    "JobId": 1,
    "JobName": "sample string 2",
    "CommandName": "sample string 3",
    "SourceDatabase": "sample string 4",
    "TargetDatabase": "sample string 5",
    "Status": "sample string 6",
    "Scheduleddate": "2025-04-26T02:30:16.8632107-04:00",
    "Active": true,
    "BackupRequired": true,
    "submittedDate": "2025-04-26T02:30:16.8632107-04:00",
    "BackupDatabaseCompleted": "2025-04-26T02:30:16.8632107-04:00",
    "RestoreDatabaseCompleted": "2025-04-26T02:30:16.8632107-04:00",
    "Processed": true,
    "Error": true,
    "CreateDate": "2025-04-26T02:30:16.8632107-04:00",
    "ModifiedDate": "2025-04-26T02:30:16.8632107-04:00",
    "DBTICKET": "sample string 10",
    "SRCSQLSERVER": "sample string 11",
    "DSTSQLSERVER": "sample string 12",
    "OVERWRITEIFEXIST": true,
    "SCRUBNEWDATABASE": true,
    "GETNEWBACKUP": true,
    "SendEmail": true
  }
]

text/html

Sample:
[{"JobId":1,"JobName":"sample string 2","CommandName":"sample string 3","SourceDatabase":"sample string 4","TargetDatabase":"sample string 5","Status":"sample string 6","Scheduleddate":"2025-04-26T02:30:16.8632107-04:00","Active":true,"BackupRequired":true,"submittedDate":"2025-04-26T02:30:16.8632107-04:00","BackupDatabaseCompleted":"2025-04-26T02:30:16.8632107-04:00","RestoreDatabaseCompleted":"2025-04-26T02:30:16.8632107-04:00","Processed":true,"Error":true,"CreateDate":"2025-04-26T02:30:16.8632107-04:00","ModifiedDate":"2025-04-26T02:30:16.8632107-04:00","DBTICKET":"sample string 10","SRCSQLSERVER":"sample string 11","DSTSQLSERVER":"sample string 12","OVERWRITEIFEXIST":true,"SCRUBNEWDATABASE":true,"GETNEWBACKUP":true,"SendEmail":true},{"JobId":1,"JobName":"sample string 2","CommandName":"sample string 3","SourceDatabase":"sample string 4","TargetDatabase":"sample string 5","Status":"sample string 6","Scheduleddate":"2025-04-26T02:30:16.8632107-04:00","Active":true,"BackupRequired":true,"submittedDate":"2025-04-26T02:30:16.8632107-04:00","BackupDatabaseCompleted":"2025-04-26T02:30:16.8632107-04:00","RestoreDatabaseCompleted":"2025-04-26T02:30:16.8632107-04:00","Processed":true,"Error":true,"CreateDate":"2025-04-26T02:30:16.8632107-04:00","ModifiedDate":"2025-04-26T02:30:16.8632107-04:00","DBTICKET":"sample string 10","SRCSQLSERVER":"sample string 11","DSTSQLSERVER":"sample string 12","OVERWRITEIFEXIST":true,"SCRUBNEWDATABASE":true,"GETNEWBACKUP":true,"SendEmail":true}]

application/xml, text/xml

Sample:
<ArrayOfJobRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/CCAPI.Models">
  <JobRequest>
    <Active>true</Active>
    <BackupDatabaseCompleted>2025-04-26T02:30:16.8632107-04:00</BackupDatabaseCompleted>
    <BackupRequired>true</BackupRequired>
    <CommandName>sample string 3</CommandName>
    <CreateDate>2025-04-26T02:30:16.8632107-04:00</CreateDate>
    <DBTICKET>sample string 10</DBTICKET>
    <DSTSQLSERVER>sample string 12</DSTSQLSERVER>
    <Error>true</Error>
    <GETNEWBACKUP>true</GETNEWBACKUP>
    <JobId>1</JobId>
    <JobName>sample string 2</JobName>
    <ModifiedDate>2025-04-26T02:30:16.8632107-04:00</ModifiedDate>
    <OVERWRITEIFEXIST>true</OVERWRITEIFEXIST>
    <Processed>true</Processed>
    <RestoreDatabaseCompleted>2025-04-26T02:30:16.8632107-04:00</RestoreDatabaseCompleted>
    <SCRUBNEWDATABASE>true</SCRUBNEWDATABASE>
    <SRCSQLSERVER>sample string 11</SRCSQLSERVER>
    <Scheduleddate>2025-04-26T02:30:16.8632107-04:00</Scheduleddate>
    <SendEmail>true</SendEmail>
    <SourceDatabase>sample string 4</SourceDatabase>
    <Status>sample string 6</Status>
    <TargetDatabase>sample string 5</TargetDatabase>
    <submittedDate>2025-04-26T02:30:16.8632107-04:00</submittedDate>
  </JobRequest>
  <JobRequest>
    <Active>true</Active>
    <BackupDatabaseCompleted>2025-04-26T02:30:16.8632107-04:00</BackupDatabaseCompleted>
    <BackupRequired>true</BackupRequired>
    <CommandName>sample string 3</CommandName>
    <CreateDate>2025-04-26T02:30:16.8632107-04:00</CreateDate>
    <DBTICKET>sample string 10</DBTICKET>
    <DSTSQLSERVER>sample string 12</DSTSQLSERVER>
    <Error>true</Error>
    <GETNEWBACKUP>true</GETNEWBACKUP>
    <JobId>1</JobId>
    <JobName>sample string 2</JobName>
    <ModifiedDate>2025-04-26T02:30:16.8632107-04:00</ModifiedDate>
    <OVERWRITEIFEXIST>true</OVERWRITEIFEXIST>
    <Processed>true</Processed>
    <RestoreDatabaseCompleted>2025-04-26T02:30:16.8632107-04:00</RestoreDatabaseCompleted>
    <SCRUBNEWDATABASE>true</SCRUBNEWDATABASE>
    <SRCSQLSERVER>sample string 11</SRCSQLSERVER>
    <Scheduleddate>2025-04-26T02:30:16.8632107-04:00</Scheduleddate>
    <SendEmail>true</SendEmail>
    <SourceDatabase>sample string 4</SourceDatabase>
    <Status>sample string 6</Status>
    <TargetDatabase>sample string 5</TargetDatabase>
    <submittedDate>2025-04-26T02:30:16.8632107-04:00</submittedDate>
  </JobRequest>
</ArrayOfJobRequest>