Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Access Rights Manager (ARM) formerly 8MAN > ARM - Knowledgebase Articles > Locate and delete scheduled ARM jobs using SQL

Locate and delete scheduled ARM jobs using SQL

Updated November 22, 2018

Overview

This article details how to use SQL queries to remove old preset jobs from ARM that cannot be deleted from the Job Overview.

clipboard_e638d80fc1ead2bc1505a206b0df0970f.png

Environment

  • Access Rights Manager

 

Resolution

  1. Create a backup of your current SQL database.
  2. In the SQL database, create three individual queries using the following content:
    Replace <name_of_DB> with the name of your SQL database. Default: _8MANDB
    1. SELECT [_id]
      , [_property]
      , [_value]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_values]
      WHERE [_id] in ( SELECT [_child_id]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_relations]
      WHERE [_parent_id] IN (
      SELECT [_id]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_types]
      WHERE [_type] = 'E3198714-88B4-4B8C-B211-AC7C997A1ECE' )
      
    2. SELECT [_id]
      , [_property]
      , [_value]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_values]
      WHERE [_id] in (
      SELECT [_id]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_types]
      WHERE [_type] = 'E3198714-88B4-4B8C-B211-AC7C997A1ECE' )
      
    3. SELECT [_parent_id]
      , [_child_id]
      , [_relation_property]
      , [_row_id]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_relations]
      WHERE [_parent_id] IN (
      SELECT [_id]
      FROM [<name_of_DB>] . [dbo] .[_predefined_job_object_types]
      WHERE [_type] = 'E3198714-88B4-4B8C-B211-AC7C997A1ECE' )
      
  3. Run the queries.
  4. Delete any entries - likely in red boxes - discovered by the queries.

    joboverview_delete_jobs_2.png

 

 

 

Last modified

Tags

This page has no custom tags.

Classifications

Internal Use Only