Lock request in SQL Server after executing job in SAP Data Services

[Former Member]

Hi All,

I have executed one job which executes stored procedure in SQL Server. But after execution of that job it continuously executed. That's why I am getting lock request in SQL Server on that particular table. So how can I resolve it? Please help...

[Former Member · Accepted solution]

Can you check your stored procedure first? Is it happening while running it directly on the database (ie not when calling the procedure from BODS?)