Hi, all!

I'm a newbie...sorry.

Here's my problem. I don't know how to see what a scheduled DTS package
actually did...and to store those results for later review...other than have
the stored procedure(s) involved write records to a table that I've called
ImportMsgs.

When I run the package, as each step executes, a record is created logging
which "stored procedure" caused "how many" changes in "which table" at "what
date/time" along with a hardcoded message about what is going on in the
stored procedure at the time (ie "Added New Service Records", "Deleted
Cancelled Appointments", "Changed Client Addresses", etc). This works great
when I manually run the DTS package that uses these stored procedures. I
use this information extensively to track trends.

My problem is that when I schedule this DTS to run as a job (as my
supervisor demands, and, truthfully, I would prefer), under "Management",
"Jobs", and package name, the "Last Run Status" shows that it succeeded with
the right date/time, but no events are logged in my table. Is it really
running? Is data being changed in a way that I can't track? I'm getting
scared here...

Help, please.

TIA,
Rox

When you execute the package outside of a scheduled job does it update
the table? Does the length of time the package is taking correspond to
how long it should take?

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Strange that it says it succeeded, usually this has something to do with
security (when it only runs a few seconds) I would start profiler and
then kick the job off (through the scheduled job), this might help you
watch where the SQL is stopping or not running.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks for the help. I discovered that the problem lay in permissions of
the owner of each chunk of the DTS package. It's all fixed, writes info to
my table like I need, and life is good!

Thanks again!
Rox


"Ray Higdon" <rayhigdon (AT) higdonconsulting (DOT) com> wrote