Use this page to learn more about how to manually setup and start an
Agent Job in SQL
Server Management Studio (SSMS) that runs the ETL process in IFS Analysis
Models
Set up a SQL Server Agent job to start the Load SSIS IFSDW.cmd file on a schedule.
Do the following:
If the step Execute job <Job Name> stops rather quickly after start then there is something wrong since the execution of the SSIS packages takes a while. Two possible reasons are listed below:
During execution the job execution window looks like this:
If IFS Race data is used; if the job ends with an Error, after 15-30 minutes, then there were problems with one or more of the SSIS packages. To get an idea of what is wrong, try one of the following:
- Lookup the log files, available in the folder <AM Instance Home>\SSIS\SSIS\Log. The file Load SSIS IFSDW.log provides the most useful information.
- In Management Studio, examine the sysssislog system table for the database.
When the execution is complete the job execution dialog looks like this:
Even if the agent job stop with Success it does not mean that everything is ok! Always perform the following:
- Check the log file Load SSIS IFSDW.log as mentioned above and make sure that there are no errors listed.
- Open one of the cubes that you know should contain data and perform some simple browsing. This can be done in SSMS (Management Studio) by connecting to Analysis Services, browsing for the cube database and then browse for one of the Analysis Models cubes, e.g.