Checking scheduled tasks

Build 1501 on 14/Nov/2017  This topic last edited on: 15/Sep/2014, at 17:39

Applies to

All servers with scheduled tasks

Frequency

Daily, before the production starts

Tool

For SQL scheduled tasks, use SQL Management Studio.

For tasks, scheduled by Task Scheduler, use Control Panel/Task Scheduler

Where

For SQL scheduled tasks, Start > Programs> SQL Server Management Studio -Microsoft SQL servers > your server > Management > SQL Server Logs:

For tasks, scheduled by Task Scheduler, Start-Settings-Control Panel-Task Scheduler

Time required

15 minutes x server

Description

Check the job last run status, and job history.

_noteNotes

A variety of reasons (insufficient disk space, removal of required applications, passwords changes, etc.) may cause a scheduled job to fail. The only way to ensure that jobs actually run is to check them one by one.