AutoSys Workload Automation

  • Private Community
 View Only

  • 1.  Workload Automation DE Job

    Posted Jun 18, 2019 11:26 AM
    I need to sync a database view in an SQL server to another table that is in another SQL Server.
    But I was not able to create a linked server between the two to make this sync.
    How can I achieve this using workload automation and no linked server?


  • 2.  RE: Workload Automation DE Job
    Best Answer

    Broadcom Employee
    Posted Jun 19, 2019 08:15 AM
    Hi,
    You can use Stored Procedure job if this syncing can be done by some stored procedure.  If you are using SQL server, then we have MS-SQL Agent which allows you to run SQL agent jobs.

    HTH,

    Nitin Pande
    Broadcom
    Original Message