We have a SQL job that always needs to be running and have the "Start
Automatically when SQL Server Agent Starts" option enabled. We've
noticed that on occassion this job is stopped. No errors / failure
notifications.
Any idea why this would happen? How can we get this to always run, or
at least notify us when the job stops?
Thanks,
RubensAre you on the latest Service Packs ? It would also be nice if you can =mention the SQL Server version you are presetly on ... -- HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions http://www32.brinkster.com/sqlvinod
"Rubens" <rubensrose@.hotmail.com> wrote in message =news:a988e2b1.0307150438.7e58dc87@.posting.google.com...
> We have a SQL job that always needs to be running and have the "Start
> Automatically when SQL Server Agent Starts" option enabled. We've
> noticed that on occassion this job is stopped. No errors / failure
> notifications.
> > Any idea why this would happen? How can we get this to always run, or
> at least notify us when the job stops?
> > Thanks,
> Rubens|||"Vinodk" <vinodk sct@.hotmail.com> wrote in message news:<erfG7AtSDHA.2148@.TK2MSFTNGP10.phx.gbl>...
> Are you on the latest Service Packs ? It would also be nice if you can
> mention the SQL Server version you are presetly on ...
Sorry, can't believe I didn't mention that. SQL Server 2000 with SP3 on W2K SP3.
Thanks,
Rubens|||"Vinodk" <vinodk sct@.hotmail.com> wrote in message news:<erfG7AtSDHA.2148@.TK2MSFTNGP10.phx.gbl>...
> Are you on the latest Service Packs ? It would also be nice if you can
> mention the SQL Server version you are presetly on ...
Sorry, can't believe I didn't mentioned that. SQL Server 2000 SP3.
Thanks,
Rubens
No comments:
Post a Comment