Auto process Cube with SQL Agent job
(1) Connect to the Analysis server, select the database which we want it to be automatically processed. Right click on this database, choose ‘Process’:
(2) In the opening ‘Process database’ form, click the ‘Script Action to New Query Window’ as below:
(3) A query form is opened as below, copy all these code.
(4) Connect to the Database Engine, choose the Jobs node under ‘SQL Server Agent’, right click on this ‘Jobs’ node and select ‘New Job’:
(5) In the opening ‘New Job’ form, enter a Name and description for this job
(6) Choose Steps in the left page in the ‘new Job’ form, then click the ‘New’ button to open ‘New Job Setup’ form
(7) In the ‘New Job Setup’ form, please enter a name for this Step, choose the Type ‘SQL Server Analysis Services Command’, enter the Server, then paste the command in our step(3) in to the Command, and you can select the ‘Advanced’ page in the left page to configure more for this step, like log file.
After you finish the setup of step, click OK return to ‘New Job’ form.
(8) Choose ‘schedules’ and then click ‘New’ buttons as below:
(9) In the ‘New Job Schedule’ form, enter a name for this schedule, set the frequency for this job, and set the daily frequency as below, finally, click OK.
(10) Click OK to finish the creation of the job, and it has been added to the agent, it will run the process every day.
相关文档：
Orcale 的SQL 语句取得系统当前时间用：sysdate
当需要在系统当前日期上减去一天时可以用 sysdate-1
附：当只对一定数量的记录感兴趣时可以如 rownum<100
select * from SLYC_CUSTINFO_T where indbtime>sysdate-1 and OFFICE_CODE='46' and rownum<1 ......
SELECT sysobjects.name,syscolumns.name
from sysobjects,syscolumns
WHERE(sysobjects.id=syscolumns.id)
select col_name(OBJECT_ID(＇staff＇),17)
select name
from syscolumns
where id=object_id(＇你的表名＇); ......
转载说明：给正在做系统和想做系统的人，SQL博大精深，你们会用到的。——mAysWINd
一个题目涉及到的50个Sql语句
Student(S#,Sname,Sage,Ssex) 学生表
Course(C#,Cname,T#) 课程表
SC(S#,C#,score) 成绩表
Teacher(T#,Tname) 教师表
问题：
1、查询“001”课程比“002”课程成绩高� ......
关于：以前的某个程序安装已在安装计算机上创建挂起的文件操作 解决办法
以前装过sql server，后来删掉。现在重装，却出现“以前的某个程序安装已在安装计算机上创建挂起的文件操作。运行安装程序之前必须重新启动计算机”错误。无法进行下去。
步骤是：
1）添加/删除程序中彻底 ......
关于SQL Prompt
的破解文章园子里已经有不少人发过了。破解思路我也不想重复，不知道的可以参考：http://www.cnblogs.com/jintan/archive/2008/06/16/1223282.html
官方下载地址是：http://downloads.red-gate.com/SQLToolbelt.exe
接下来我就说说具体怎么做吧。我就说说最简单最傻瓜的做法，不需要懂IL照样破解！
� ......
