SSIS job runs without issue in manual but stuck when run via SQL Agent

sam nick 286 Reputation points
2021-01-22T15:29:56.247+00:00

Hi,
I have an graph that pings Salesforce, read data and does an incremental load into the SQl server DB as the destination. Daily volume of records is around 100k . Oddly, when i run this job from within Visual Studio manually, the jobs runs fine without any issue. But when i export the job and run it via the SQL Agent, it gets hung. Not sure where and why does it get hung.

Any recommendations on how to resolve this or even find out what is causing the issue. This is an Azure db.

Thank you.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-01-25T07:57:10.577+00:00

    Hi @sam nick ,

    We can View History to read the execution info by right-click the job name.

    Please refer to the following picture:

    This topic describes how to view the Microsoft SQL Server Agent job history log in SQL Server 2019 (15.x) by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects.

    60088-job-viewhistory.png

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.