Can anyone help me in calling a DTS package in a stored procedure ?

-Peri

msdb..sp_start_job or msdb..sp_add_jobschedule / msdb..sp_delete_jobschedule
/ msdb..sp_help_jobschedule depends on requirements. And leave all routine
work for SQL Server Agent. Belive me it will do it better. It is created
for.

You can even start your DTS package from a trigger.


"Peri" <peri (AT) cspl (DOT) com> wrote