Database View: view_job_status

This view is one of a suite of related views supporting the primary status display of CSV2. The suite includes:

  1. view_cloud_status (also used by timeseries)
  2. view_cloud_status_flavor_slot_detail_summary
  3. view_cloud_status_flavor_slot_detail
  4. view_cloud_status_flavor_slot_summary
  5. view_cloud_status_slot_detail_summary
  6. view_cloud_status_slot_detail (also used by timeseries)
  7. view_cloud_status_slot_summary
  8. view_job_status (also used by timeseries)
  9. view_vms

The view_job_status details current job information including counts, HTCondor job scheduler and agent status, and the validity on any required authentication certificates.

Columns:

  • group_name (String(32)):

    Is the name of the group owning the jobs.

  • Jobs (Integer):

    Is the total number of jobs.

  • Idle (Integer):

    Is the total number of jobs in the ‘idle’ state. These jobs are waiting to run..

  • Running (Integer):

    Is the total number of jobs in the ‘running’ state.

  • Completed (Integer):

    Is the total number of jobs in the ‘completed’ state.

  • Held (Integer):

    Is the total number of jobs in the ‘held’ state.

  • Other (Integer):

    Is the total number of jobs in a state other than any of those listed above.

  • foreign (Integer):

    Is the the total number of jobs controlled by the group’s job scheduler (see ‘htcondor_fqdn’ below) which do not belong to this group.

  • htcondor_status (Integer):

    Is a flag indicating the status of the group’s job scheduler. A value of one indicates that the job scheduler is running. A value of zero indicates that the job scheduler is not running. Any other value indicates a mis-configuration of the job scheduler.

  • agent_status (Integer):

    Is a flag indicating the status of the csv2-htc-agent associated with the group’s job scheduler. A value of one indicates that the agent is running. A value of zero indicates that the agent is not running. Any other value indicates a mis-configuration of the agent.

  • htcondor_fqdn (String(128)):

    Is the Fully Qualified Domain Name (FQDN) of the server hosting the group’s HTCondor job scheduler.

  • condor_days_left (Integer):

    Is the number of days remaining on the HTCondor host certificate. A value less than one indicates that the certificate has expired. A NULL value indicates that a certificate has not been configured and may not be required (see ‘htcondor_status’ above).”

  • worker_days_left (Integer):

    Is the number of days remaining on the VM worker certificate. A value less than one indicates that the certificate has expired. A NULL value indicates that a certificate has not been configured and may not be required (see ‘agent_status’ above).”