MicroStrategy ONE

List Jobs statement

Lists all active jobs on an Intelligence Server.

Copy 
LIST [ALL | ACTIVE] JOBS [MAXCOUNT number_of_jobs] [FOR USER "login_name"] [FROM PROJECT "project_name"];

where:

  • MAXCOUNT number_of_jobs is the maximum number of jobs that are listed, of type integer. The most recent jobs are listed first.

  • USER "login_name" is the login name of the user for whom jobs are to be listed, of type string.

  • PROJECT "project_name" is the name of the project for which jobs are listed, of type string.

Examples

Copy 
LIST ACTIVE JOBS;
Copy 
LIST JOBS FOR 
 USER "dsmith";  

ResultSet Columns

DESCRIPTION: The description of the job, returned as a string.

JOB_ID: The ID of the job, returned as an integer.

JOB_STATUS: The status of the job, returned as an integer:

  • 0: Ready

  • 1: Executing

  • 2: Waiting

  • 3: Completed

  • 5: Canceled

  • 6: Stopped

  • 7: Waiting on governor

  • 8: Waiting for autoprompt

  • 9: Waiting for project

  • 12: Waiting for fetched results

OWNER: The owner of the job, returned as a string.