Stephanie_Metzger_757

How to execute a SQL Server stored procedure from a SQL job?

Discussion created by Stephanie_Metzger_757 on May 20, 2015
Latest reply on Oct 12, 2017 by Judith_Gitahi_1741
First, I apologize if this question has been asked before.  I am running version 9 of the Automation Engine.  I have a SQL Agent set up to run SQL jobs.  I have several stored procedures I would like to call, but I can't seem to get them to work.  I followed the steps in the documentation, with no luck.
This is the code in my process tab:
SQL_SET_STATEMENT_TERMINATOR TERM='!';
DECLARE @result int;
EXEC @result = SPUploadExternalData 'QCBT_Contacts',NULL,'1','1','1','1','0','1';
select @result;!

The job immediately errors out with nothing written to the report.  I have triple checked the security roles and the login has rights to execute the stored procedure.  I can run SQL statements with no problems, I just can't seem to get stored procedures to execute.  Thank you.

Outcomes