Tag Archives: SQL Agent Jobs

SSIS: Integration Packages on 64bits

Posted on May 2, 2013 by mauriciorpp

And so I’m back to designing SSIS packages. Its a fun activity really. SQL Server Integration Services is a really powerfull platform to move data around. It can read anything and write anywhere (and even if it can’t directly access … Continue reading →

Posted in SQLServer | Tagged , , , | Leave a comment

SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.

Posted on April 16, 2013 by mauriciorpp

While dealing with older SQL versions sometimes you stumble upon some not-so-known error, and have to find a simple way to fix it. Pinal Dave points us to a simple solution if you have this error when maintaining some SQL … Continue reading →

Posted in SQLServer | Tagged , , | Leave a comment

Monitoring SQL Agent jobs

Posted on September 28, 2012 by mauriciorpp

And this is the second post of today, only a quick link to a great script from SQLFool. That girl is really a script junkie – and I love her scripts. http://sqlfool.com/2012/09/sql-agent-job-script-2/ It is extremely useful to be able to … Continue reading →

Posted in SQLServer | Tagged , , , , | Leave a comment

SQL Job with Maintenance Plan misteriously failing

Posted on September 12, 2012 by mauriciorpp

This post is to group details about one possible cause of failure on SQL Agent Jobs that have Maintenance Plans inside. Because the Job engine is not very clever when storing the messages returned from the SSIS Package (that is … Continue reading →

Posted in SQLServer | Tagged , , , , | Leave a comment