 | |
How can I see if a scheduled DTS has run ?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
How can I see if a scheduled DTS has run ? -
07-07-2006
, 08:40 AM
#2
| |||
| |||
|
|
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 ? |
How did you schedule it ?
Bye
#3
| |||
| |||
|
|
Hello Screaming, 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 ? How did you schedule it ? Bye |
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
-------------------------------------------------
#4
| |||
| |||
|
|
"Davide Rossetti" <rossetti71 (AT) gmail (DOT) com> schreef in bericht news:7c768b021530058c86ff436b4fd09 (AT) msnews (DOT) microsoft.com... Hello Screaming, 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 ? How did you schedule it ? Bye 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. |
You shold see the scheduling Job with the name of your package, right-click
on the Job --> 'View Job history'
Bye
#5
| |||
| |||
|
|
Hello Screaming, 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 |
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.
#6
| |||
| |||
|
|
"Davide Rossetti" <rossetti71 (AT) gmail (DOT) com> schreef in bericht news:7c768b0215314e8c86ffcd0c80505 (AT) msnews (DOT) microsoft.com... Hello Screaming, 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 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. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.