Home Forums SQL Server 2005 SQL Server Newbies Connditional executing of script RE: Connditional executing of script
Sergey Vavinskiy
SSCarpal Tunnel
Points: 4469
More actions
September 19, 2009 at 7:32 am
#1055951
There are several ways, but I would create 2-step job using your 2 scripts and put something like
if (select count(*) from FROM [ReorderS]) > 0
in the beginning of second step.