I want to run a stored procedure using SQL Server Agent.
This stored procedure uses OLE and calls sp_AOCreate.
When testing I used the following:
sp_configure ‘show advanced options’, 1;
sp_configure ‘Ole Automation Procedures’, 1;
to enable OLE.
How should i run this job under SQL Server Agent?
Does running the above script only work for the current session, or does it apply to all uses in the database?