Scheduled packages not executing
- From: "KGoradia" <kaushalgoradia@xxxxxxxxx>
- Date: 20 Jul 2005 12:38:12 -0700
I am rather new to DTS, and the problem I have seems to be rather odd.
I have a scheduled DTS Package (say Pkg-S) that simply executes a bunch
of other packages sequentially based on the workflow properties.
Pkg-S executes Pkg-A, Pkg-B and Pkg-C first.
Then, on success of Pkg-A, Pkg-D is executed, on success of Pkg-B,
Pkg-E is executed, and on success of Pkg-C, Pkg-F is executed.
So basically I want all the packages (A to F) to execute given that the
respective predecessor packages executed successfully.
The problem is, on schedule, Packages A to C execute without error,
however, Packages D to F don't even get started.
All packages executed without problem through the designer, and the
package log as well as the job log shows no errors. For testing
purposes I even added a simple package that would insert a field to a
table and set this package to execute "On Fail" for Pkgs A to C, and
even that does not seem to execute. In other words, Pkgs A to C seem to
neither complete successfully, nor fail, as far as the workflow is
concerned. And according to the logs, they complete without the
slightest problem.
None of the options about "Fail package on step fail", etc have been
turned on, and logging on the server is turned on for all packages.
Any help would be greatly appreciated.
.
- Follow-Ups:
- Re: Scheduled packages not executing
- From: Narayana Vyas Kondreddi
- Re: Scheduled packages not executing
- Prev by Date: Re: DTS Issue - Urgent
- Next by Date: Re: Mailing from DTS
- Previous by thread: Migrate FK and PK constraints from Oracle
- Next by thread: Re: Scheduled packages not executing
- Index(es):
Relevant Pages
|