Solved

Maintenance Job for BI Server

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the fileā€¦
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.

706 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

18 Experts available now in Live!

Get 1:1 Help Now