title: Sql Agent job does not execute
body: <p>I have create a sql agent job as follows</p>
  
  <pre><code>USE [Database]
  GO
  DECLARE @return_value int
  EXEC @return_value = [dbo].[StoredProc_RPT_Test]
  @batch_id = Null,
  @StartDate = Null,
  @EndDate = Null
  SELECT 'Return Value' = @return_value
  GO
  </code></pre>
  
  <p>The Stored Procedure StoredProc_RPT_Test calls another stored procedure when all parameters are null. Which inserts data into a permanent table.</p>
  
  <p>I can run StoredProc_RPT_Test manually and it works fine. The data is present in permanent table. However when i run the sql agent job no results in the permanent table? </p>
  
  <p>Really puzzled. Is this because iam calling two stored procedures?</p>