Sree-

Option I:

Turn on profiler to trace all errors and stored procs.

Option II:

Go step by step in the job for each proc ..in query analyzer until you hit the...

Sree-

Option I:

Turn on profiler to trace all errors and stored procedures. Check the proc name where the error appears

Option II:

Go step by step in the job for each procedure ..in...

You could look at MOM (Microsoft Operations Manager). Also AppManager from NetIQ has some great tools for multiple SQL server management.