GET api/JobRequest
Request Information
URI Parameters
None.
Body Parameters
None.
Response Information
Resource Description
Collection of JobRequestName | Description | Type | Additional 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>