Hi,

This may sound a silly question, but here goes...

We have following objects created to send jobs to SQL Agent;

------
SET theServer = Server.CreateObject("SQLDMO.SQLServer")
SET theJob = Server.CreateObject("SQLDMO.Job")
SET theStep = Server.CreateObject("SQLDMO.JobStep")
SET theJobSchedule = Server.CreateObject("SQLDMO.JobSchedule")
SET sendAfter = Server.CreateObject("SQLDMO.JobStep")
SET failed = Server.CreateObject("SQLDMO.JobStep")

theServer.Connect...

...
-----

And when we destroy objects/close the connection, we do this.

-----
SET theServer = Nothing
SET theJob = Nothing
SET theStep = Nothing
SET theJobSchedule = Nothing
SET sendAfter = Nothing
SET failed = Nothing
SET allJobs = Nothing
SET theResults2 = Nothing
theConnection2.DisConnect
SET theConnection2 = Nothing
-----

Since only theConnection2 object was explicitly opened the connection to the database, we also explicitly terminate the connection. For other objects, we can only destory them, right?

Thanks in advance,
kerroppa