SSAS Articles 
Management SQL 2005, SSAS 2005: Using ascmd.exe To Create SQLAgent Jobs That Give You Completion Status
Management SQL 2005, SSAS 2005: Using ascmd.exe To Create SQLAgent Jobs That Give You Completion Status
| SQL 2005, SSAS 2005: Using ascmd.exe To Create SQLAgent Jobs That Give You Completion Status |
| Written by Steve Novoselac |
| Tuesday, 18 March 2008 22:59 |
|
In SQL2005, you can create SQL Agent jobs. They can be scheduled, have multiple steps, alert, notify, etc. Pretty great setup. There are some downfalls though. Like in order to call a job from a job, you need to execute the second job with T-SQL. Thing is, it doesn’t run synchronously. It runs asynchronously, which really stinks if you want to wait to see if the second job completes successfully or what not. Read more... |
Tags: 2005, article, tool
Latest Author Articles
- Office 2010: Excel 2010, What-If Analysis aka Microsoft Finally has Built in Cube/OLAP Writeback!
- SSASMeta – C# App to Log Info About SSAS Objects
- Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA
- SQL Job – Check Cube Valid Data as Last Step
- Using Offline OLAP to Develop Cube Reports Without SSAS
