ManageEngine® SQLDBManager Plus Jobs and Backup | ||
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.
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:
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. |
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. |
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. |
Replication Details |
Performance |