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
- SQL Job – Check Cube Valid Data as Last Step
- Using Offline OLAP to Develop Cube Reports Without SSAS
- Microsoft BI Client Tools: Easing the Transition from Excel 2003 to Excel 2007 – PivotTable Layout and Design
- SQL 2005, SSAS 2005: Using ascmd.exe To Create SQLAgent Jobs That Give You Completion Status
- SQL 2005: OpenRowset, Dynamic MDX and Variable Scope
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Passing MDX parameters in Reporting Services reports
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
- SQL Server Data Warehouse Cribsheet
- Using AS Data Mining to Add Forecast Values to a Cube
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
