Also, without seeing your code a common thing many people forget to do is close their connections properly in ADO to cleanup the objects. Check your number of Connections (even...

VBScript is not exactly the same as VBA but for the most part instantiating the SQL Drive in plain form should give the same results. Try Micheal's code by creating...

Reporting Services has the ability to export to Text file including on schedule to a share of your choosing. You might want to consider that option. Or have them view...

Unfortunately I don't have my QA in front of me but when you connect via QA there are certain options such as SET ANSI_NULLS already set on. VBA connects in...

So Are you saying that example data would have looked like this?

KP  Cat

1    1

1    3

2    1

2    3

for you to get this

KP   cat1       cat2    cat3  cat4

1      y           no       y       no

2      y           no     ...

When you say report, what do you mean. Are you using Reporting Services or some other reporting tool or that they just run the SP and if so from what...

Look at MS suggestion on how to determine what you need.

http://support.microsoft.com/kb/889654

Can you post your current code (alter anything confidential please)

What do those packages do different from other packages that don't fail? Check job owner, is it different?

As I recall you cannot kick of by using the the linked server name but instead you have to use the Server Name parameter of sp_start_job, see BOL. If you...

You problem is sp_start_job returns 1 only if the job could not be started, not if it failed.

Take a look at sp_help_job as it might help you in this case...

For me it happen with jobs connecting to Oracle and the server had to be stopped and restarted. Believe that turned out to be a driver issue.

What are your jobs...

Is it the same packages failing all the time or does it vary? Are there any that never fail?

So where is the count represented in that?

If I understand your original query correctly you really add a lot of extra work with the subquerys and distinct to accomplish this query

SELECT

 'CONV 1' AS Conveyour,

 info AS...