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 what [...]
Comments | 1,406 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 [...]
Comments | 2,366 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 [...]
Comments | 857 views
