sql agent/job executing question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Alexander Nenashev (nenashev_at_hotbox.ru)
Date: 06/08/04

Next message: Rea Peleg: "dts retrieves 0 rows when scheduled..."
Previous message: John Peterson: "Re: How to call a sub-package by name only?"
Next in thread: Allan Mitchell: "Re: sql agent/job executing question"
Reply: Allan Mitchell: "Re: sql agent/job executing question"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 8 Jun 2004 16:54:08 +0200

i guess when sql agent is executing a job and
time has come to run it again while the job is still running,
sql agent just doesn't run it but waits untill the job is complete.
do i guess right.
is there info in bol?

Next message: Rea Peleg: "dts retrieves 0 rows when scheduled..."
Previous message: John Peterson: "Re: How to call a sub-package by name only?"
Next in thread: Allan Mitchell: "Re: sql agent/job executing question"
Reply: Allan Mitchell: "Re: sql agent/job executing question"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: SQL Job error handling
... / KILL from the reskit to see if the process is active and if so kills it. ... The executible that I call is our enterprise backup solution Tivoli Storage Manager. ... As far as SQL job is concerned the step is still executing. ... Only stoping and starting of SQL Agent resets job status Is there a way perhaps to fail a step if it went over some time period? ...
(microsoft.public.sqlserver.server)
SQL Jobs dont complete
... This started because the user for the SQL Agent was changed earlier today. ... On noticing this strange behaviour, the user was changed back to the original ... it apprears in the 'Executing ...' ... as Enterprise manager simply hangs and needs to be closed using Task Manager. ...
(microsoft.public.sqlserver.server)