Tag Archives: sql tasks

Cannot edit job steps in SQL Server 2008 R2 Management Studio on 64 bit windows.

If you’re running SQL Server 2008 R2 and find that when you try to open a job steps for the second time you get the error “Creating an instance of the OCM component with CLSID {E80*************}” from the IClassFactory failed … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , | 3 Comments

Variable history sizes in SQL Agent Jobs

If you have lots of jobs then you will need to adjust the max history sizes in the SQL Server Agent but what if you have one or two jobs that run every few minutes which hog all the log … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , | Leave a comment