Re: Massive DTS job (5 days and i am nervous)
From: N (raasen_at_hotmail.com)
Date: 06/19/04
- Next message: Mookieweb: "Re: Insert into 2 tables"
- Previous message: N: "Re: Massive DTS job (5 days and i am nervous)"
- In reply to: Tom Moreau: "Re: Massive DTS job (5 days and i am nervous)"
- Next in thread: N: "Re: Massive DTS job (5 days and i am nervous)"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Jun 2004 15:24:36 +0200
Hehehehe
The server i am running this package (QA) on is 8.00.194
Our development transform server and our production transform server are
8.00.760 (SP3).
And to think this is a production job i was forced to run on our QA server
due to management not wanting our website data out of date by two three days
and the data is usually out of date by a day and nothing happens over a
weekend in anycase....
;)))
Ah well.....
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:O7bKytfVEHA.3012@tk2msftngp13.phx.gbl...
> If you have SQL Server 2000 SP3 (or SP3a), then you may be able to get
that
> with fn_get_sql(). Check out the BOL for more details. In future, you
can
> simply run the Profiler and trace the SP:StmtStarted events.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> .
> "N" <raasen@hotmail.com> wrote in message
> news:%23Y6MRnfVEHA.212@TK2MSFTNGP12.phx.gbl...
> Hi
>
> I have inherited a DTS job that takes about 5 days to run.
> This job is made up of about 20 stored procedures and some vbscript and so
> on.
> There is a bit of a process log that is kept in a table which is basically
a
> log of a start of a stored proc and then logs an end time for the stored
> proc. The stored procs are made up of loads of sql statements. Is there
any
> way i could see which statement is being executed at the current point in
> time? dbcc inputbuffer just gives me the "exec stored_proc" command used
in
> the SQL task. I can see that something is happening as the disk space
usage
> is increasing and the CPUTime and DISKIo are going up for the spid
executing
> the sql task. There are also no blks for any of the processes so i am
> certain nothing is blocking anything. I however, would like to know which
> sql statement is being executed just to satisfy myself that this thing is
> not hanging on one sql statement the entire time....
>
> any ideas?
>
>
- Next message: Mookieweb: "Re: Insert into 2 tables"
- Previous message: N: "Re: Massive DTS job (5 days and i am nervous)"
- In reply to: Tom Moreau: "Re: Massive DTS job (5 days and i am nervous)"
- Next in thread: N: "Re: Massive DTS job (5 days and i am nervous)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
