BSA: Job run fails with an error: "JOB is already running against SERVER"

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Server Automation Suite


    APPLIES TO:

    BMC BladeLogic Server Automation Suite



    PROBLEM:

    After running a job, you see an error in the Job Results panel noting that the job is already running against one or more of the target servers.


    SOLUTION:

     

    This can occur if an appserver goes down while running WorkItem threads for a job, or if there are database connectivity issues during a job run.  You will see a message such as:
     
     

      
    Error Job '<job name>' is already running against same target '<target name>'
      
    Run the below queries and return the result to BMC Support:  

     

      
    select j.name,j.job_id,j.job_version_id,jr.job_run_id,jr.progress_status_id,jrd.result_id,jrd.device_id,jrd.progress_status_id from job j left join job_run jr on j.job_id = jr.job_id and j.job_version_id = jr.job_version_id left join job_result jrr on jr.job_run_id = jrr.job_run_id left join job_result_device jrd on jrr.result_id = jrd.result_id where (jr.progress_status_id not in (3,4,7) or jrd.progress_status_id not in (3,4,7)) and j.name = '<job name>';
      

    and if the job is a Compliance, Discovery, Snapshot or Audit Job:

      
    select j.name,j.job_id,j.job_version_id,jr.job_run_id,jr.progress_status_id,jrc.result_id,jrc.component_id,jrc.progress_status_id from job j left join job_run jr on j.job_id = jr.job_id and j.job_version_id = jr.job_version_id left join job_result jrr on jr.job_run_id = jrr.job_run_id left join job_result_component jrc on jrr.result_id = jrc.result_id where (jr.progress_status_id not in (3,4,7) or jrc.progress_status_id not in (3,4,7)) and j.name = '<job name>';
       

    If the error message is something like "<job name> is already running", then look at this KA: 000084565.

     


    Article Number:

    000088196


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles