2

I have;backup ,rebuild Indexes , Update Stats and few other jobs like space alerts, replication jobs etc which run frequently on SQL Server 2102-SP2, Build Number:11.0.5058.0

and I do not see any log sucess/Failure for few jobs :

EXEC msdb.dbo.sp_help_jobhistory 
@job_name = N'Database_Full_Backup_Daily11pm' ;
GO--NO log of Sucess or fail, 

but the job ran and I see backup files stored on my backup location and I see the database last backup taken date is yesterday 11pm

and there are no other backup jobs are running at all My backup job uses a custom script not maintenance plans Owner of the job are same for all jobs all jobs are enabled. I do not see the history via Right click on job -view history also. I see agent-properties-history--Limit size 1000, 100 chosen

but for few like below, I see history

EXEC msdb.dbo.sp_help_jobhistory 
@job_name='Replication agents checkup'
GO----I see history

EXEC msdb.dbo.sp_help_jobhistory 
@job_name = N'Distribution clean up: distribution' ;
GO----I see history

what could be wrong here ? any ideas experts? Please help

migrated from stackoverflow.com Jul 24 '15 at 1:25

This question came from our site for professional and enthusiast programmers.

  • Check out this blog from Pinal Dave: blog.sqlauthority.com/2014/02/27/… – FutbolFan Jul 23 '15 at 17:51
  • Thank you Nepali Rookie but, my job run 1 time every day .. – Nick Jul 23 '15 at 18:13
  • Its mssqltips.com/sqlservertip/1070/… – Nick Jul 23 '15 at 18:15
  • To me it sounds like, you may have probably reached your max log size limit. How long have you been running this job? You probably may want to setup a maintenance task to cleanup your history log. – FutbolFan Jul 23 '15 at 18:25
  • 1
    USE msdb SELECT * FROM dbo.sysjobhistory, for this i have all logs other than the jobs i have mentioned above and , i have tested a job to fail and log and now looks like the logs are stored, my backups run tonight, once they run i will know if my change worked or not..Thank you very much for the help ... – Nick Jul 23 '15 at 19:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.