Re: How can I see if a scheduled DTS has run ?
- From: Davide Rossetti <rossetti71@xxxxxxxxx>
- Date: Fri, 7 Jul 2006 14:52:07 +0000 (UTC)
Hello Screaming,
"Davide Rossetti" <rossetti71@xxxxxxxxx> schreef in bericht
news:7c768b021530058c86ff436b4fd09@xxxxxxxxxxxxxxxxxxxxxxx
Hello Screaming,I used the Import Data Wizard in SQL Server Enterprise Manager,
Howdy,How did you schedule it ?
I scheduled a DTS task to run daily at 3 PM.
How can I see this has been done ? Is there a place you can see when
the
last run happened ?
Bye
clicking All
Tasks with the RMB,
then following all steps (from where to where, etc...) I asked to
schedule
the import of the data on every day
at 3 PM, without an enddate, I aksed to save this as/my DTS package.
Now I can see my dts package in the Enterprise Server.
In Enterprise Manager select 'Management' --> SQL Server Agent --> Jobs
You shold see the scheduling Job with the name of your package, right-click on the Job --> 'View Job history'
Bye
.
- Follow-Ups:
- Re: How can I see if a scheduled DTS has run ?
- From: Screaming Eagles 101
- Re: How can I see if a scheduled DTS has run ?
- References:
- Re: How can I see if a scheduled DTS has run ?
- From: Screaming Eagles 101
- Re: How can I see if a scheduled DTS has run ?
- Prev by Date: Re: How to retrieve this value in activex?
- Next by Date: Re: DTS How to parse a varcharfield
- Previous by thread: Re: How can I see if a scheduled DTS has run ?
- Next by thread: Re: How can I see if a scheduled DTS has run ?
- Index(es):
Relevant Pages
|
