Viewing 4 posts - 1 through 5 (of 5 total)
Thank you for your reply Orlando. So all I need to do is create a job agent that has a step to call the msdb.dbo.sp_purge_jobhistory passing in the frequency...
December 3, 2014 at 7:00 am
Does this same stored procedure (msdb.dbo.sp_purge_jobhistory) also clean up SQL Server Reporting Services (SSRS) subscriptions managed by the SQL Server Agent Jobs?
Please see attached snapshot for more information on what...
December 2, 2014 at 2:45 pm
Does this same stored procedure (msdb.dbo.sp_purge_jobhistory) also clean up SQL Server Reporting Services (SSRS) subscriptions managed by the SQL Server Agent Jobs?
Please see attached snapshot for more information on what...
December 2, 2014 at 2:26 pm
Does this same stored procedure (msdb.dbo.sp_purge_jobhistory procedure) also clean up SQL Server Reporting Services subscriptions managed by the SQL Server Agent Jobs?
Thank you.
Best Regards,
Mary Anne
December 2, 2014 at 2:13 pm
Viewing 4 posts - 1 through 5 (of 5 total)