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

Question

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.

Answer 1

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.

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.