• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

sql server view history log

I have a job that runs every minute to check for new data and send out an email

Each time it runs there is an entry put in the history log

Is there a way to automatically delete/cleanup so that only the current day of history show?
0
johnnyg123
Asked:
johnnyg123
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Right click sql server agent -> properties -> history -> check remove agent history polder than '3' days
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now