Creating Synonyms for RA JD EDwards Agents on MS SQL Server Databases

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Synonyms are created on the master database instead of the JDE database where F986110 & F986111 exist.

Environment

Release : 12.3.4

Component : RA JD EDWARDS

Resolution

The SQL statement mentioned in our documentation is just an example and mentions the [master] schema as example. The syntax to create a synonym can be found here. 

Object Librarian (F986111) - used to get the JD Edwards run number:

USE [master]

GO

/****** Object:  Synonym [dbo].[F986111]    Script Date: 06/07/2015 07:34:63 ******/

CREATE SYNONYM [dbo].[F986111] FOR [<SYSTEM_DB>].[<Object_Librarian_Schema].[F986111]

GO

The Example Replacement Value mentioned in the same automic documentation can be replaced for this table synonym:

USE [JDE_PY910]