Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Maintenance Job for BI Server

Posted on 2014-11-02
1
Medium Priority
?
211 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 2000 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

[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.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

885 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