Hi,
There is a job with 2 steps, each executing a SSIS package. The job
runs everyday at 1.00 am, 4.00 am and at 01.00 pm. This job usually
takes 15 minutes to run.
Issue: It hangs up indefinitely until someone notices. This happens
with any of the schedules randomly. (The job does not fail, but just
hangs up). It runs fine when it is cancelled and re-run.
The SSIS packages are stored in MSDB.
Observations: There is output file configured for each step with
append option. But, when I open the output file when the job is stuck,
I have noticed that there is nothing logged in there. ( Not even that
Job started:...). So I believe, the job hangs up even before it calls
the SSIS.
Questions: An ideas on this issue??? and actually, when does an agent
starts logging information in the configured output file? In this
scenario, as the job hangs up even before it starts logging
information, is the issue with the agent itself? But none of other jobs have
issues on this server.
Thank you
R__
[font="Verdana"]Renuka__[/font]