G Sunny (12/5/2016)
Hi,SQL agent log backup job is failing intermittently in one of our Prod server,
In job history i can not see the exact issue why it has failing...i can see below
@CleanupTime = 120, @Compress = 'Y', @CopyOnly = 'N', @ChangeBackupType = 'N', @BackupSoftware = NULL, @checksum = 'N', @BlockSize = NULL, @BufferCount = NULL, @MaxTransfer... The step failed.
where can i look for the exact issue, appreciate any responses.
Thanks
Sunny
You can check the job history table and look at the message there -
select *
from msdb.dbo.sysjobhistory
where job_id = 'YourJobID'
You can also add an output file if things are getting truncated. Go to the Properties for the job, select the edit for the step that is failing in the job, go to Advanced and that is where you can put in an output file and path. Make sure it's a directory that SQL Agent has permissions to, like the default JOBS directory that gets setup on install...whatever. Just make sure it has permissions.
Sue