In SSMS Object explorer, if you expand the nodes to see the stored proc, right-click and select Script Stored procedure as -> Execute To -> New Query Editor window, it will show you a query editor window with the right syntax. This is sort of what it will look like (and what you need to do).DECLARE @RC int
DECLARE @batch_seq int
DECLARE @activity_seq int
DECLARE @return_value int
-- TODO: Set parameter values here.
EXECUTE @RC = [PFW].[dbo].[RwSP_TransferOpProduct]
@batch_seq
,@activity_seq
,@return_value OUTPUT
SELECT @return_value;
run job with SP with parametr
Posted - 04/26/2012 : 11:06:51
