Databases Reference
In-Depth Information
In the New Job Step dialog box (see Figure 3-23), in the Type list box, click SQL Server Analysis
Services Command.
5.
6.
In the Run As list box, select a proxy that has been defined to use the Analysis Services Com-
mand subsystem.
A user who is a member of the sysadmin fixed server role can also select SQL Agent Service
Account to run this job step.
7.
Click to place your cursor in the Command text box and paste the script that you previously
copied from the SQL Engine query window (in the previous step) and then click OK.
Figure 3-23 shows the script pasted into the Command text box of a new step of a job for
processing.
FIGURE 3-23
The New Job dialog box.
On the Schedules page, organize schedules for the job.
8.
Figure 3-24 shows that we want to load our
AdventureWorks
tabular database with fresh data
from the
AdventureWorksDW
every hour, starting at midnight and ending at midnight.
Search WWH ::
Custom Search