1 Replies - 541 Views - Last Post: 26 November 2011 - 12:16 PM

#1 marvinmartian  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 36
  • Joined: 07-October 09

stored procedure in SQL Job

Posted 20 November 2011 - 11:26 PM

i have a stored procedure which a run using sql server agent via job and set a schedule for it
this is the stored proc

EXEC dbo.Proc_UpdateExpiringAppt 477


when the parameter is exact it executes the job but when i try to put it like this

EXEC dbo.Proc_UpdateExpiringAppt @CtrlNo


it does not execute the job
Is This A Good Question/Topic? 0
  • +

Replies To: stored procedure in SQL Job

#2 Martyr2  Icon User is offline

  • Programming Theoretician
  • member icon

Reputation: 4316
  • View blog
  • Posts: 12,096
  • Joined: 18-April 07

Re: stored procedure in SQL Job

Posted 26 November 2011 - 12:16 PM

This looks like it relates to your other question. Read my response there and see if this helps. @CtrlNo should be set to a single integer value and I am assuming your stored procedure is expecting a single integer value.

:)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1