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 |
|
chourasia
Starting Member
3 Posts |
 Posted - 2004-09-15 : 09:08:56
|
| I have a query in Job step no. 1 as:IF (select count(*) from tnp where date=GetDate() -1) > 0SO, if count comes > 0, then I want to execute something(may be query/stored proc/command) here so that it should be in step no. 1 only...I don't want it to switch to step no. 2.Else it should go to step no. 2.So what do I do?Plz help...it's urgent.Thanks.Gaurav |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-15 : 10:11:36
|
is this what you need??IF (select count(*) from tnp where date=GetDate() -1) > 0begin...endelse if (other condition)begin...endGo with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Retry in Job Step (Sql Server Agent)