Home Forums SQL Server 2005 Administering pass variables between SQL Server tasks in a JOB RE: pass variables between SQL Server tasks in a JOB
sureshr69
SSC Veteran
Points: 253
More actions
September 8, 2009 at 5:13 am
#1050399
Use the combination of sp_add_job_step and @command option with dynamic SQL. Have provisions for creating and dropping them(job steps) at runtime. It will be possible.
Thanks
Suresh Ramamurthy