New Topic/Question
Reply
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
1 Replies - 458 Views - Last Post: 26 November 2011 - 12:16 PM
#1
marvinmartian
- New D.I.C Head
Reputation: 1
- Posts: 34
- 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
when the parameter is exact it executes the job but when i try to put it like this
it does not execute the job
this is the stored proc
when the parameter is exact it executes the job but when i try to put it like this
it does not execute the job
Is This A Good Question/Topic?
0
MultiQuoteReplies To: stored procedure in SQL Job
#2
Martyr2
- Programming Theoretician
-
Reputation: 3872
- Posts: 11,405
- 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
|
|
| 