Jobhistory table lock

• rs

  SSCrazy

  Points: 2819

  More actions

  November 3, 2003 at 8:50 am

  #65565

  Hi,

  Is there any way to lock sysjobhistory table, i want to stop using the ClearAll button in jobhistory window.

  Thanks in advance.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  November 3, 2003 at 9:39 am

  #480678

  Deny access to msdb..sp_purge_jobhistory.