Write backup job failure/success stauts with details in another table [Remote Server database]

• shamshad.ali

  Hall of Fame

  Points: 3850

  More actions

  June 12, 2018 at 2:17 am

  #362823

  I have several databases on difference servers, we have scheduled db backups which mostly fails due to space issue or some other reasons, I know how to setup email alerts but checking losts of emails is waste of time and odd practice to check every server email generated. I want to write backup job failure/success stauts with details in an central database table on another computer which is linked server configured. We have other plateforms like oracle, DB2 etc. with same requirement so I just want to write the status of all those jobs and their latest status I can query from where there is any problem found otherwise nothing to worry. This will save time and give quick report if found any backup failure somewhere.

  I don't know how to setup or call the script which writes teh status in my target database

  .
  Please guide if someone has done this or any working idea?

  create table tbl_backup_detail
  (
  Program    varchar    (510),
  backup_finish_date    varchar(100)    ,
  type    varchar(10),
  backup_size_bytes    decimal(14,0),
  database_name    varchar(256),
  server_name    varchar(256),
  Message    varchar    (200),
  currentTime varchar(50)
  )
  This is a sample target table where i want to write the status of backup job.

  Regards,
  Shamshad Ali.