Re: fine tuned tracing for sql server job execution
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/08/04
- Next message: Allan Mitchell: "Re: sql agent/job executing question"
- Previous message: Allan Mitchell: "Re: DTS Excel to Oracle: Buffer Overflow"
- In reply to: Rea Peleg: "fine tuned tracing for sql server job execution"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 20:32:27 +0100
Profiler will not do you much good neither will the other things. The job
is probably still failing (well the package anyway) and not bubbling up the
error message.
Have a look here
http://support.microsoft.com/?kbid=269074
I would log onto the box as the SQL Server Agent service account and try to
execute manually
-- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Rea Peleg" <rea_p@afek.co.il> wrote in message news:uoCKfZWTEHA.2128@TK2MSFTNGP11.phx.gbl... > Hi every body > I'm thinking of using sql server profiler and/or the windows performance > logs (with sql server objects counters), to trace a problematic job which > fails to retrieve any rows by executing a dts (which inbcludes transfare > data tasks). > The dts works just fine by it self. > When scheduled, it does not fail the job or generate any massage,just no > rows are retrieved.. > > Can you recomend the best practice with these tools for such a tracing task? > I'm not sure which of the sqlserver objects counters i should use if at > all.. > Can sql server profiler have some insite here?? > Thanks again > Rea > >
- Next message: Allan Mitchell: "Re: sql agent/job executing question"
- Previous message: Allan Mitchell: "Re: DTS Excel to Oracle: Buffer Overflow"
- In reply to: Rea Peleg: "fine tuned tracing for sql server job execution"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
