question

basit 1 avatar image
basit 1 asked

JOB History

Hi All, I have a issue at my server. I have created a job for backup all database but when i check the Job history it show blank. what can be cause for it. is there any configuration issue or any thing Else... Thanks Basit
jobjob-history
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What version of SQL Server? And what edition?
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Do you have a job that deletes the Job History? Or a job step that does this? Check the job history table (msdb.dbo.sysjobhistory) in the MSDB database. If you want to reconstruct the backup history, you can use the following query: SELECT Server_Name, Database_Name, CASE [type] WHEN 'D' THEN 'Database' WHEN 'L' THEN 'Transaction Log' WHEN 'I' THEN 'Differential Database' WHEN 'F' THEN 'File or Filegroup' WHEN 'G' THEN 'Differential File' WHEN 'P' THEN 'Partial' WHEN 'Q' THEN 'Differential Partial' ELSE '???' END AS Backup_Type, backup_start_date, recovery_model, backup_size, compressed_backup_size FROM msdb.dbo.backupset
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
I have seen this and still find it on some jobs. One thing that I set on all jobs where I want to see the outcome is to set the important steps to have their output logged. Go to the Advanced tab for the steps you are interested in and tick Log to Table. If you want a history of all executions then tick Append, otherwise only the last execution will be stored. Once the job has run you can come back here and click the View button to see the output.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tracy McKibben avatar image
Tracy McKibben answered
There is a configurable limit to how many history events that SQL Agent will keep, both overall and per job. What are your limits set at?
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

basit 1 avatar image basit 1 commented ·
from where i can see this limit...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.