all groups > sql server dts > july 2006 >
You're in the

sql server dts

group:

How can I see if a scheduled DTS has run ?


Re: How can I see if a scheduled DTS has run ? Davide Rossetti
7/7/2006 1:50:32 PM
sql server dts:
Hello Screaming,

[quoted text, click to view]


How did you schedule it ?
By

Re: How can I see if a scheduled DTS has run ? Davide Rossetti
7/7/2006 2:52:07 PM
Hello Screaming,

[quoted text, click to view]

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

How can I see if a scheduled DTS has run ? Screaming Eagles 101
7/7/2006 3:40:00 PM
Howdy,

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 ?
--
Filip
http://users.skynet.be/101airborne
Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi
-------------------------------------------------

Re: How can I see if a scheduled DTS has run ? Screaming Eagles 101
7/7/2006 4:25:42 PM
"Davide Rossetti" <rossetti71@gmail.com> schreef in bericht
news:7c768b021530058c86ff436b4fd09@msnews.microsoft.com...
[quoted text, click to view]

I used the Import Data Wizard in SQL Server Enterprise Manager, 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.

--
Filip
http://users.skynet.be/101airborne
Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi
-------------------------------------------------

Re: How can I see if a scheduled DTS has run ? Screaming Eagles 101
7/10/2006 12:00:00 AM
"Davide Rossetti" <rossetti71@gmail.com> schreef in bericht
news:7c768b0215314e8c86ffcd0c80505@msnews.microsoft.com...
[quoted text, click to view]


Aha, there it is .... that's good news. Thanks !

I can also see my Job didn't run and why, it looks as if I don't have access
rights to run a Job,
but that's something I'll have to discuss here in the plant. It's not a
technical issue I can see, but Company Policy.

Nothing to do with SQL server, but y'r name sounds Italian,
so if you are I immagine you had a wonderful time yesterday seeing Italy win
the World Championship of Soccer.
Congrats. I'm glad, since I have family in Calabria, Southern Italy.

Re: How can I see if a scheduled DTS has run ? Davide
7/10/2006 5:06:25 AM
Hello Screaming,

[quoted text, click to view]

yeah !!!! Great celebration Here!!!!!

AddThis Social Bookmark Button