There may be times where you want to terminate a job which is running on the TIBCO Spotfire Statistics Services (TSSS) server, for example if a job has been running for an unexpectedly long amount of time. It is possible to stop the execution of a long running job by deleting that job. To identify any long running jobs start by opening the TIBCO Spotfire Statistics Services URL API for Jobs in a web browser.

Example of Jobs URL API:  

http://<servername>:<port>/<servicename>/api/v8/jobs

Note: In the example URLs, the servername, port, and servicename must be modified to match your installation. The URL is case sensitive.

The information displayed on this page allows administrators to find the Job ID for any long running job based on its "Status Code" (which should be either RUNNING or QUEUED) and the time from the columns "Queued Time (ms)", "Engine Time (ms)" and "Server Time (ms)" (displayed in milliseconds). For more information on the various job statuses and the jobs URL API, see the documentation reference here.

Once the Job ID for the job to be deleted has been identified from the Jobs URL, it can be terminated by running the following URL API for "delete":

http://<servername>:<port>/<servicename>/api/v8/administration/delete?jobId=<JobID>

or for example, to remove job 25 which appears to have hung in the "RUNNING" state for many hours:

http://myTSSS:8080/SplusServer/api/v8/administration/delete?jobId=25

Note: In the example URL, the servername, port, and servicename must be modified to match your installation. The URL is case sensitive. <JobID> must be replaced with actual Job ID of the job to be terminated as identified on the jobs URL.

In the above example, Job ID 25 will get deleted permanently. The next time you send a request for jobs to /api/v8/jobs, the deleted job should not appear on the list. If it still appears, refresh your browser to clear the cache.


 

This article describes how to identify and terminate long running job on the TSSS server.

Doc: Administration Service API > delete

• https://docs.tibco.com/pub/sf_statsvcs/12.3.1/doc/html/TIB_sf_statsvcs_12.3.1_urlapi/urlapi/topics/delete.html

Doc: TIBCO Spotfire Statistics Services URL API > Jobs

• https://docs.tibco.com/pub/sf_statsvcs/12.3.1/doc/html/TIB_sf_statsvcs_12.3.1_urlapi/urlapi/topics/jobs.html