An interface for performing basic operations on a jobsDB $Name: $ $Revision: 1.97 $

The following operations are supported. For a formal definition, please review the Service Description.

• CancelJob
  Schedules a job for cancellation. Only works for non-short queue jobs.
• CheckSyntax
  Returns error-as-string if syntax error is found, null if no errors.
• FindJob
  Same as FindJobDataSet, but returns in Job format
• 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
• 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.
• GetFailedOutputAsJobs
  Lists failed output jobs
• GetOutputDownloadsAsJobs
  Lists available output downloads
• GetPendingOutputAsJobs
  Lists pending output
• GetPlan
  Returns a sql-server plan based on target and qry.
• Heartbeat
  Submits a heartbeat job to JobsService
• ListServers
  List available targets and queues.
• StatusJob
  Returns a job's current status. This is an int, where 0=ready,1=started,2=cancelling,3=cancelled,4=failed,5=finished
• 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)
• 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.
• 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.
• 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.
• getStatusHTML
  Return an html representation of the job status.