MicroStrategy ONE

List Job Properties statement

Lists the properties of a job to a MicroStrategy Intelligence Server.

Copy 
LIST [ALL] PROPERTIES FOR JOBjob_id;

where:

JOB job_id is the ID of the job for which job properties are to be listed, of type integer.

Example

Copy 
LIST ALL PROPERTIES 
 FOR JOB 123;

ResultSet Columns

CLIENT_MACHINE: The machine performing the job, returned as a string.

CREATION_TIME: The date and time the job was created, returned as a string.

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

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

JOB_PRIORITY: The priority assigned to the job, returned as an integer/string.

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.

PROJECT: The name of the project the job is associated with, returned as a string.

PROJECT_ID: The ID of the above project, returned as an integer.