How are you starting the JobA? are you starting the box or JobA
individually using FORCE_STARTJOB? What is the status or Box job when the
JobA completes?
Regards,
*Venkat*
--
This electronic communication and the information and any files transmitted
with it, or attached to it, are confidential and are intended solely for
the use of the individual or entity to whom it is addressed and may contain
information that is confidential, legally privileged, protected by privacy
laws, or otherwise restricted from disclosure to anyone else. If you are
not the intended recipient or the person responsible for delivering the
e-mail to the intended recipient, you are hereby notified that any use,
copying, distributing, dissemination, forwarding, printing, or copying of
this e-mail is strictly prohibited. If you received this e-mail in error,
please return the e-mail to the sender, delete it from your computer, and
destroy any printed copy of it.
Original Message:
Sent: 4/17/2025 6:57:00 PM
From: Srini Venkat
Subject: Dependent job not starting after condition met when included under a box job
We have created & run other jobs successfully previously with a condition and also setting dependency under a box so that is what makes this so frustrating.
We have job B with condition S(job A).
When both of them defined with a box_name parameter (both under the same BOX job), then even after successful run of job A, job B does not start.
When I move them both out of the box - clear out the box name parameter - then if run job A, job B runs right after
job B is sql command job i.e. directly executes a stored procedure - that is the only thing that is different from our existing jobs with similar, prior successful setup (they are SSIS jobs).
Any idea if I am doing something wrong? I tried d(job A) as the condition as well with no luck.