I use SQL Agent a ton. It is like my go to place to schedule jobs and tasks. Problem is, there are pieces “missing”. Like if a job hangs, you can have it auto stop after a given amount of time. It doesn’t alert on changes to a job, etc, etc. I asked on twitter [...]
View Comments | 2,896 views
Sometimes you have some pretty complex ETL’s going in SSIS, and you might have multiple projects/solutions that need to call other SSIS Packages or SQL Agent Jobs and you have a pretty big production going on. You might have an ETL solution that needs to kick off other packages, and you can either import those [...]
View Comments | 4,782 views
Running a SQL Agent job to do an ETL/Cube Processing, you might also want to check the status of the cube after you process it, just to make sure. Create a job step that is a T-SQL type, and DECLARE @forecast VARCHAR(10) SELECT @forecast = CAST("[Measures].[Forecast-Part]" AS VARCHAR(10)) FROM OPENROWSET(‘MSOLAP’, ‘Data Source=localhost;Initial [...]
View Comments | 1,230 views
