ManageEngine® SQLDBManager Plus


Jobs and Backup

<< Prev

Home

Next >>

 

SQL Server - Jobs and Backup Details

SQLDBManager Plus provides a wide range of performance metrics on number of Jobs and Backup process running in the SQL server. They are:

Jobs Details | Create Job | Backup Details | Restore Details

SQLDBManager Plus also allows you to easily manage these Jobs and Backup processes in bulk. Just select the Job(s) you wish to manage and then select any one of the option ( 'Start Job, Stop Job, Delete Job, Enable Job, Disable Job') from the pull-down menu.

Job Details

Displays the performance metrics of various Jobs running in SQL server.

Parameters

Description

Job Name

Displays the name of the job.

Current Status

Gives the current status of the job

Last Run Status

Gives the last run status of the job

Run Date & Time

Gives the date & time for which the jobs are scheduled to run.

Job Time (ms)

Gives the time taken by the job.

Retries Attempted

Gives the number of times the scheduled jobs attempted to run.

Health Displays the health of each job running in the SQL Server.

You can also create a job right from SQLDBManager Plus console. To do so, follow the steps given below:

  1. Click on 'Create job' link.

  2. Provide Job Name, select the Owner from the pull-down menu, select the Category and the Description.

  3. You can also set the status as either 'Enable' or 'Disable' if you choose to run the Job later.

  4. Provide the Step Name, Type, Run As, Database on which it should run, enter the SQL Command you wish to execute. You can repeat this process to add 'n' number of steps. You can also edit them at a later stage or even delete a step if found not required.

  5. Set the action On Success Action either as 'Go to the next step' or 'Quit the job reporting success' or 'Quit the job reporting failure'.

  6. Set the Retry attempts and Retry interval (minutes).

  7. Set the action On Failure Action either as 'Quit the job reporting failure' or 'Go to the next step' or 'Quit the job reporting success'.

  8. If you like to schedule the job, click on Schedule and provide the following information.
    1. Provide a Name for the schedule job.
    2. Select the Frequency at which you want the job to be executed : Daily / Weekly / Monthly.
    3. If its Daily, then choose the occurance at which you want this job to run daily: Occurs once / Multiple Times. If it Occurs once, provide the time (hh:mm). Also select the date from which the job needs to run.
    4. If the frequency is Weekly, choose the days on which you want this job to run and provide whether it recurring every 'nth' weeks.
    5. If the frequency is Monthly, choose the nth day of every nth month or select whether it should run on 'nth' day of every 'nth' week of every nth month.

  9. If you like to receive/send notifications of these jobs, click on Notifications, and select Email notification when the job either succeeds, fails or finishes to the appropriate operator. If the operator name is not specified, then select 'New Operator' and provide the Name and Email ID of the same.

  10. You can also set notification and allow jobs to be written into Windows Event Log files when it succeeds, fails or finishes.

 

Go to Top

 

Job History Table

Displays the performance metrics of various Jobs history running in SQL server. You will be able to view SQL Job's history when you click on the corresponding SQL Job from Job History table. This will show the step by step job execution history for that corresponding job in a pop-up window.

Parameters

Description

Run Date & Time

Displays the date & time for which the scheduled jobs has run

Step ID

Displays the ID of the each step in the job. The Step ID will become 0 for last step of a completed job.

Step Name

Displays the Name of the step.

Job Status

Dislays the status of the job execution in each step.

Duration

Displays the Total time elapsed in the execution of that step (shown in HH:MM:SS format).

Retries Attempted

Displays the number of times the scheduled jobs attempted to run.

Message Displays any SQL Server error or messages.

 

Go to Top

 

Backup Details

Displays the performance metric about various SQL backup set present in the SQL server.

Parameters

Description

DB Name Displays the name of the database involved in the backup operation.
Start Displays the date and time of the back up operation started.
End Displays the date and time of the back up operation ended.
Expiration Displays the date and time the back up operation is supposed to expire.
Damaged If the value is 1, then it means that the damage to database was detected while this back up was being created. However the back up operation continued despite the errors.
Size Displays the size of the back up set (in bytes).
Physical Name Displays the physical name of the back up device.
Backup Age (Hours) Displays the number of hours passed since the back up operation was completed.

 

Go to Top

 

Restore Details

Displays the performance metrics about various Restore operation in the SQL Server.

Parameters

Description

DB Name Displays the name of the destination database for which the restore operation operate upon.
Restore by Displays the name of the user who performed the restore operation on the database.
Restore Type Displays the type of restore operation performed which could be either Database / File / Filegroup / Log / Verifyonly / Differential / Revert.
Started Displays the date and time of the restore operation.
Restore From Displays the physical name of the backup file created.
Restore To Displays the name of the file where the backup was restored to.

 

Go to Top

 


<< Prev

Home

Next >>

Replication Details

Performance