SQLTeam.com | Weblogs | Forums

Synchronized X ASynchronized


#1

parent-childs package gets called from proc. where i am maintaining set execution para value for @parameter_value = 0 but because of this my proc gets completed and package still continue in back end. on line user will not confirm when actual execution gets completed.
Is there anyway/setting to confirm that proc complete only after package completes.

T.I.A


#2

you can poll dbo.sysjobhistory in msdb

dbo.sysjobhistory (Transact-SQL)