CreateObject & agent on server

Hi,i have a agent that import record from SQL 2k.

I have created a ADO connection ad line XX:

Set ADOcon = CreateObject(“ADODB.Connection”)

If i lunch agent from list agent or from menu, it work fine (with user Administrator).If i schedule this agent, the server run it, but result on error in server console “Operation is disallowed in this session” when perform line XX.

Are you idea?

Thanks

Subject: CreateObject & agent on server

Check your Agent Settings and the security tab needs to be set to option 3 which allows it to run this type of agent.

Subject: RE: CreateObject & agent on server

Thank you Scott, now works.Bye