Recently, we have implemented few jobs and we were testing the jobs. After our test runs successfully, we wanted to clear Job’s history, so we can have accurate job status. I have found following SQL to delete job’s history:
This will clear all history for the specified job. If you wanted to clear job history up to specific date, you can use following:
If you wanted to clear job history for ALL SQL jobs, you should just execute:
|
Learn SQL and database management at SQLYoga for articles, tutorials, and tips to improve your skills and streamline data operations. Join our community!
October 15, 2012
SQL SERVER: Clear Job History
Labels:
SQL Job,
SQL Server,
SQL Yoga,
Tejas Shah
![](http://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjujG7o11Gd8EfKSoNWPmXkr2i-ecUBVAc3mAYLnhpEddxxd2heF4nxDNQvIGAjg61qu2sRK7PxuCZVEzJnrzJ3zmyKlk-Wyl2XfCbKYea6-t-kOiZcq6GKTVtqWoC9l5pePjhwFfSPozNC2UgRw2JaSC7qsYaeWeUv_KTcqIhCgZLDzLE/s220/Tejas.png)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment