Stored procedure when executed in before sql does not work
Posted: Thu Oct 31, 2019 6:26 am
Hi,
Hope all are doing great. We migrated 8.5 version of jobs (Unix env.) to 11.5 version (Linux env.) recently. We are having trouble with a job that is executing a SQL Server stored procedure from ODBC connector. The same job runs fine in 8.5 but in 11.5 job completes but does perform the required activity, it completes in 0.02 sec in 11.5 version and takes 3 mins in 8.5.
The design is simple and straight forward, ODBC connector and peek, just kicks off the SQL Server stored procedure in the "Before SQL" section.
Used this in the Before SQL section:
Please note this code is working fine in 8.5 version.
Could you please let me know if anything is missing or needs correction for having it run in 11.5 version?
Thanks in advance.
Hope all are doing great. We migrated 8.5 version of jobs (Unix env.) to 11.5 version (Linux env.) recently. We are having trouble with a job that is executing a SQL Server stored procedure from ODBC connector. The same job runs fine in 8.5 but in 11.5 job completes but does perform the required activity, it completes in 0.02 sec in 11.5 version and takes 3 mins in 8.5.
Code: Select all
ODBC connector -> peek
Used this in the Before SQL section:
Code: Select all
Begin
exec dbname.dbo.sp_name
End;
Could you please let me know if anything is missing or needs correction for having it run in 11.5 version?
Thanks in advance.