Migrate goal relationships for assigned entities

task australia Updated Sep 10, 2026 1 min read migrate-goal-relationships-for-assigned-entities-egm.md

Migrate the existing goal relationship data from the Goal Relationship [sn_gf_goal_m2m_relationship] table by running the scheduled job.

Before you begin

Role required: admin

About this task

If you’ve upgraded from Alignment Planner Workspace v4.1.1 or v5.0.1 to Strategic Planning v2.0.1 and have created m2m relationship with lens entities other than Company, Business Unit, Department, and Portfolio, you can migrate those lens entities from the Goal Relationship [sn_gf_goal_m2m_relationship] table to the Goals table to access and manage the goals for those lens entities in the respective portfolio plans.
Migrating goal relationships data for assigned entities is a one-time job, and not meant to be on a schedule.
Running the job populates the Assigned entity type and Assigned entity fields on the Goal form based on the data in the Goal Relationship [sn_gf_goal_m2m_relationship] table if you have any customized lenses other than the lens entity types, Company, Business Unit, Department, and Portfolio.

Procedure

Navigate to All > System Definition > Scheduled Jobs.
Search for and click the Migrate goal relationships for assigned entities scheduled job.
On the Scheduled Script Execution form:
1. Ensure that the frequency is selected as On Demand in the Run field.
2. In the Run this script field, list the entities configured in the Goal Assigned Entity Configuration [sn_gf_assigned_entity_config] table that you want to migrate the goal relationship data for.
  
  For parameters information, see Scheduled Script Execution form.
Click Execute Now.

Parent Topic:Configuring goals in Strategic Planning

48 lines · 3.0 KB Wrap lines

---
title: Migrate goal relationships for assigned entities
description: Migrate the existing goal relationship data from the Goal Relationship \[sn\_gf\_goal\_m2m\_relationship\] table by running the scheduled job.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/it-business-management/scenario-planning-in-spw/migrate-goal-relationships-for-assigned-entities-egm.html
release: australia
product: Scenario Planning in SPW
classification: scenario-planning-in-spw
topic_type: task
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Configuring goals in Strategic Planning, Configure, Portfolio Planning in Strategic Planning Workspace, Strategic Planning, Strategic Portfolio Management]
---

# Migrate goal relationships for assigned entities

Migrate the existing goal relationship data from the Goal Relationship \[sn\_gf\_goal\_m2m\_relationship\] table by running the scheduled job.

## Before you begin

Role required: admin

## About this task

- If you’ve upgraded from Alignment Planner Workspace v4.1.1 or v5.0.1 to Strategic Planning v2.0.1 and have created m2m relationship with lens entities other than **Company**, **Business Unit**, **Department**, and **Portfolio**, you can migrate those lens entities from the Goal Relationship \[sn\_gf\_goal\_m2m\_relationship\] table to the Goals table to access and manage the goals for those lens entities in the respective portfolio plans.
- Migrating goal relationships data for assigned entities is a one-time job, and not meant to be on a schedule.
- Running the job populates the **Assigned entity type** and **Assigned entity** fields on the [Goal form](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-business-management/scenario-planning-in-spw/goal-form-egm.md) based on the data in the Goal Relationship \[sn\_gf\_goal\_m2m\_relationship\] table if you have any customized lenses other than the lens entity types, **Company**, **Business Unit**, **Department**, and **Portfolio**.

## Procedure

1. Navigate to **All** &gt; **System Definition** &gt; **Scheduled Jobs**.

2. Search for and click the **Migrate goal relationships for assigned entities** scheduled job.

3. On the Scheduled Script Execution form:

1. Ensure that the frequency is selected as **On Demand** in the **Run** field.

2. In the **Run this script** field, list the entities configured in the Goal Assigned Entity Configuration \[sn\_gf\_assigned\_entity\_config\] table that you want to migrate the goal relationship data for.

For parameters information, see [Scheduled Script Execution form](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-business-management/scenario-planning-in-spw/scheduled-script-execution-form-egm.md).

4. Click **Execute Now**.

**Parent Topic:**[Configuring goals in Strategic Planning](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-business-management/scenario-planning-in-spw/configuring-goal-framework-apw.md)