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

Joakim,

Have another job that checks on your job.

Ilya

"Joakim Olesen" <jol (AT) logosconsult (DOT) dk> wrote

Hi Ilya Margolin

I don't really see how this would be possible, can you please explain?

Joakim


"Ilya Margolin" <ilya_no_spam_ (AT) unapen (DOT) com> skrev i en meddelelse
news:%23li7bsDPFHA.3076 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

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 (AT) logosconsult (DOT) dk> wrote