CasJobs
An interface for performing basic operations on a jobsDB $Name: $ $Revision: 1.51 $
The following operations are supported. For a formal definition, please review the Service Description.
-
FindJob
Same as FindJobDataSet, but returns in Job format -
getStatusHTML
Return an html representation of the job status. -
CancelJob
Schedules a job for cancellation. Only works for non-short queue jobs. -
SubmitShortJobObject
Submits a short job. Returns an exception if job takes too long, Dataset if job did not. Autocomplete is currently disabled; the param does nothing. -
FindJobDataSet
Searches a usr's jobs with parameters given in predicate. Predicate is of where clause form, ex. 'taskname="some_name" and rows=some_number -
SubmitJob
Creates new job entry and schedules a query for later completion. Returns the jobid of the created job. This method is only necessary for long jobs. Autocomplete is disabled (param does nothing) -
GetPlan
Returns a sql-server plan based on target and qry. -
GetOutputDownloadsAsJobs
Lists available output downloads -
FindJobWithStatusDataSet
A join of jobs and status, where j is jobs and s is status. setSize is the number of jobs to return. Position is a multiplier on setSize, ie top 20, or next 20, etc. User can append select and/or where. justCount set to true returns a dataset with the total # of jobs for the specified conditions. Set size is how many jobs to return, position is the nth set of the specified size. So if you had 10 jobs, setSize was 2 and position was 1, it would return jobs 3&4. maxChars is the maximum # of characters to return for any single textfield. Setting this to -1 will return everything. -
Heartbeat
Submits a heartbeat job to JobsService -
GetFailedOutputAsJobs
Lists failed output jobs -
SubmitShortJob
Submits a short job. Returns an exception if job takes too long, Dataset if job did not. Autocomplete is currently disabled; the param does nothing. -
SubmitShortJobVOTABLE
Submits a short job. Returns an exception if job takes too long, Dataset if job did not. Autocomplete is currently disabled; the param does nothing. -
ListServers
List available targets and queues. -
GetPendingOutputAsJobs
Lists pending output -
CheckSyntax
Returns error-as-string if syntax error is found, null if no errors. -
StatusJob
Returns a job's current status. This is an int, where 0=ready,1=started,2=cancelling,3=cancelled,4=failed,5=finished