Knowledge Center

Navigate topics

Jobs

Experda has 2 levels of job views:

  1. The first level is the company overview, which allows you to see all jobs across all servers.
  2. The second level is the server job.

From either view – press on the job name to retrieve the job history from the managed server msdb database.

Jobs Company Overview

Legend
1 To reach the company job overview, press the “company overview” on the top left of the main server hirerechy control and then press “jobs”.
2 The main job table specifications

This table is updated every 60 seconds from each active monitored server.

Name Description
Job Name The name of the job
Server Name The MSSQL server that runs the job
Enabled Wether the job is enabled or disabled
Run status The last running status of the job
Last duration The last running duration time of the job
Last run The last time of the job
Next run The estimated next time the job will run (for scheduled jobs)
Scheduled Wether the job is scheduled or not
Created The time the job was created
Modified The time the job information was modified
Description A description of the job
Owner The name of the login that owns the job
Start step The first step of the job
Steps The total steps of the job
Status The current status of the job
3 The Job Filters. Use these filters / search capabilities to find particular jobs.

Jobs Server Overview

The job server overview provides a server filtered job header information. The displayed table and filters are similar to the Job Company Overview table and filters.

Specific Job History

To see the job history of a specific job, double click the job name in the job’s tables or press the 3 dots on the left of each job row. The job’s history will be retrieved from msdb of the managed server and will depend on the purging policy of the managed server’s msdb (usually 30 days back are reserved).

Legend
1 The selected job’s name + latest status
2 This main job history instance table. Each row in this table is a single job occurance, which can end in a successful execution of all the job’s steps, partial execution or failed execution.

From each row you can drill down to the details of the job occurance.

Name Description
Run Datetime The time of the beginning of the job occurance
Duration The total duration of the job occurance
Status The status of the job occurance
Steps The total steps that ran in the job occurance
3 tA drill down of each step in the job occurance.

Name Description
Step name The name of the step
Status The end result of the step’s execution.
Run time The start time of the step
Duration The total duration of the step until end result has been reached
Message A detailed message. Usually the TSQL output of the steps.

Request a demo

Fill out your details. 

We’ll get back to you soon.

With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.

Contact Sales

Fill out your details. 

We’ll get back to you soon.

Request a Proposal.

Fill out your details. 

We’ll get back to you soon.

Contact us

Fill out your details. 

We’ll get back to you soon.

Need professional DBA services?

Fill out your details. 

We’ll get back to you soon.

With Experda, database teams trade manual work with automations and replace clunky operations with streamlined workflows.

Need professional BI services?

Fill out your details. 

We’ll get back to you soon.

Get help from Experda

Fill out your details. 

We’ll get back to you soon.

Request a demo

Fill out your details. 

We’ll get back to you soon.

This website uses cookies to remember you and improve your experience. To find out more see our Privacy Policy.