Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-14 : 08:56:53
|
| madhu writes "How to add a condition in to job, for ex:I want run a job until the table recods become null means zero, Please helpt me out for this issue.ThanksMadhu" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-14 : 09:04:23
|
| >> I want run a job until the table recods become null means zerowhat does this mean?Have the job call an sp and put the condition in the sp.You can have the sp disable the job when a condition is met but it's usual to just do a check in the sp.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Jobs in sql server