Solved

Maintenance Job for BI Server

Posted on 2014-11-02
1
203 Views
Last Modified: 2016-02-11
I saw two BI jobs on my SQL BI Server. Is it the default job setup when installing the AS / SSIS services ? What are they for ?

Tks
SSIS01.png
SSIS02.png
0
Comment
Question by:AXISHK
1 Comment
 
LVL 7

Accepted Solution

by:
Ray earned 500 total points
ID: 40458975
SSIS projects, packages, parameters, environments, and operational history are all stored in the SSISDB database so if you have hundreds of SSIS packages or packages that run every few minutes you could see how the database storing all the historical information would grow exponentially. The SSIS Server Maintenance job is used to control the DB size.

SSIS Server Operations Records Maintenance is the stored procedure that cleans up history. Default retention period is 365 days

SSIS Server Max Version per Project Maintenance is the stored procedure that cleans up how many project versions to keep. Default is 10
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question