Re: How to restart executing jobs after server reboot?
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 30 Apr 2005 07:52:38 +0100
There may be a couple of ways open to you
Both would require:
Have a job that starts at agent startup.
1. In your jobs you create add a step at the start that inserts into a table the time it started. , Add anoher step at the end
which updates that same row to show when it finished. Anyjobs that failed or were stopped midway through will have no EndTime
value.
2. You could look in the msdb.dbo.sysjobhistory table in the message attribute for the following
"The job was stopped prior to completion by Shutdown". You can then look at when it was executed etc.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
<annem96145@xxxxxxxxxxx> wrote in message news:1114722340.235401.165580@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Has anyone had the issue where you have jobs executing or retrying and
> the server maintenance people reboot the server? After the reboot, I
> have been manually restarting any jobs that were executing or retrying.
> Is there a way to restart the jobs automatically/progammatically? Is
> there a table in the msdb database that can be queried to get this
> information - then a job could be created that runs when sqlserver
> agent starts to find jobs that were executing/retrying and restart
> them. Any ideas? Thanks.
>
.
- References:
- How to restart executing jobs after server reboot?
- From: annem96145
- How to restart executing jobs after server reboot?
- Prev by Date: Re: which authentication mechanism should I use?
- Next by Date: Re: EXport from EXce using DTS
- Previous by thread: How to restart executing jobs after server reboot?
- Next by thread: Distributed transaction on linked server.
- Index(es):
Relevant Pages
|
