Solved

Maintenance Job for BI Server

Posted on 2014-11-02
1
198 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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
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.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
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…

939 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now