Important notes :- Scheduling SQL Server 2005

Posted Date: 25 Aug 2008	Resource Type: Articles	Category: General
Author: Prasanth Kumar S.D	Member Level: Gold
Rating:	Points: 4

Scheduling SQL Server 2005 Integration Services Packages

Users create BAM views based on data stored in an online analytical processing (OLAP) cube. The Cube Update Integration Services package refreshes the data in the cube so that OLAP views reflect the correct data.
You must run this package under SQL Server 2005 at least once for the OLAP views to work. For ongoing maintenance, you should schedule the package to run on a regular basis.
Security Note

If you restored the BAM Star Schema database or stopped SQL Server before running the Cube Update Integration Services package, you must refresh the data sources in SQL Server Analysis Manager or restart the OLAP service before you can run the package successfully.
You can schedule a saved package to execute at specific times, either once or at recurring intervals. For example:
• Daily at midnight.
• Weekly on Sunday at 06:00.
• The first or last day of the month.
A scheduled package is executed by SQL Server gent as a job.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Important notes :- Scheduling SQL Server 2005 .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: The effect of mobile phone radiation
	Previous Resource: Threats and countermeasures to an ASP.net application.
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources