SQL Server job failure I have a job that executes every 15mins on SQL Server 2008 and it comes up with the following error at least once in two days. But, it runs successfully the next time it runs.  The account that is running the stored procedure has db_owner permission on the database. Any idea why?

The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'. [SQLSTATE 42000] (Error 229).  The step failed.
Check this link: http://msdn.microsoft.com/en-us/library/ms191188.aspx
It allows you to enable Ole Automation Procedures. This change would affect the entire instance. This is turned off by default due to security. 

Other Ole procedures are here: http://msdn.microsoft.com/en-us/library/ms190501.aspx