Re: A DTS step freezes (status is just "Executing Job Step 'job name'")

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Joakim,

Write a stored procedure in which you would use sp_help_job to get start
time and execution status, sp_stop_job to stop your job and sp_start_job to
restart it. Execute this new stored procedure in your new tracking job.

Ilya

"Joakim Olesen" <jol@xxxxxxxxxxxxxxx> wrote in message
news:OoizwvDPFHA.1088@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Ilya Margolin
>
> I don't really see how this would be possible, can you please explain?
>
> Joakim
>
>
> "Ilya Margolin" <ilya_no_spam_@xxxxxxxxxx> skrev i en meddelelse
> news:%23li7bsDPFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
> > Joakim,
> >
> > Have another job that checks on your job.
> >
> > Ilya
> >
> > "Joakim Olesen" <jol@xxxxxxxxxxxxxxx> wrote in message
> > news:uIkvUCBPFHA.576@xxxxxxxxxxxxxxxxxxxxxxx
> >> Hi
> >>
> >> I have an issue with some SQL Jobs:
> >>
> >> Mostly they quit with success after 30 sec, but sometimes they just
> > freeze.
> >> For hours (and days) the Status for the job is just "Executing Job Step
> > 'job
> >> name'" and I have to manually restart the job.
> >>
> >> How can I automatically restart such jobs that seem to never quit? (It
> > would
> >> be OK to just quit the job after 5 min. because I know it never takes
> >> that
> >> long when it doesn't freeze).
> >>
> >> The DTS package that is run in the step is password protected and made
by
> > a
> >> third party company, so there is no way I can change the package
itself.
> >>
> >>
> >> Hope you can help!
> >>
> >> Joakim
> >>
> >>
> >
> >
>
>


.