You are here: Tracking Package Execution Status « MsSQL Server « IT news, forums, messages
Tracking Package Execution Status

Posted by NickName on 11/14/05 23:51

Hi,

Say, you have two inter-dependent packages of pA and pB. With the
successful execution of pA you would proceed to execute pB. And since
they would perform some repeatitive tasks on regular basis they are
scheduled as a job. But you don't want to the job to make attempt to
run pB if you know pA has failed and you want to nofiy sys adm of it.
And let's say pA has log option checked (so, there's a log file for
it). Now, it would seem to me quite clumsy to check this potentially
huge file to see if a particular package (pA here) is successful before
running pB. Any other viable and clean solution?

Yes, one could possibly combine pA and pB into one big package (pBIG),
however, for the sake of a clean and clear business process this is not
desirable since pA and pB handles
totally different business processes.

TIA.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация