How to restart executing jobs after server reboot?

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.

.

Relevant Pages

  • Re: At job not executing
    ... >output of that command will go in the user's email. ... while crontab jobs are correctly executed on ... >possible that cron keeps subsequent at jobs in the queue if the limit ... not just not executing. ...
    (comp.unix.sco.misc)
  • Re: SQL agent jobs fail after upgrading windows2000 to windows2003
    ... It sounds like you are executing something other than T-SQL in your jobs. ... > Executed as user: SQLAdmin. ...
    (microsoft.public.sqlserver.server)
  • Re: TSQL to find all running SQL Agent jobs
    ... executing. ... you can refer to system tables like sysjobs* for making the query. ... > list all jobs that are currently running ...
    (microsoft.public.sqlserver.programming)
  • Re: How to restart executing jobs after server reboot?
    ... Have a job that starts at agent startup. ... In your jobs you create add a step at the start that inserts into a table the time it started. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > have been manually restarting any jobs that were executing or retrying. ...
    (microsoft.public.sqlserver.dts)
  • Re: Please Help-windows will not update -desperate
    ... The network adapter is inactive or disconnected. ... All jobs are placed in the ... |> cleared out - the computer requires a reboot. ... |> tried to Express install again and had the same failure but when I selected ...
    (microsoft.public.windowsupdate)