Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
metro17
Starting Member
8 Posts |
 Posted - 2008-10-28 : 18:52:31
|
| I am trying to schedule a DTS package . But its says nothing, no error displays and finally it does not execute and hence a job is not created . But when I execute it immediately it is executing so . What is the problem here .Any suggestions .Appreciate responses !!!!!!!! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-29 : 04:11:52
|
Maybe it's my déjà vu.A long time ago I created a job using right click on the dts-packages. All seems to be ok, but no job appeared.Manually refresh the list of jobs and it will appear.Hope that helpsWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-29 : 05:25:40
|
| see this also. might be of helphttp://support.microsoft.com/kb/269074 |
|
|
|
metro17
Starting Member
8 Posts |
Posted - 2008-10-29 : 14:43:10
|
| I have tried refreshing it several times Mr DejaVu.If you can elaborate on that would be great . |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-30 : 09:28:24
|
Another idea - coming up while reading visa's link.Maybe you/you're login or your Server registration in Enterprise Manager is not the owner of the new created Job...[AND SO MAYBE YOU CANNOT SEE THE JOB]From visak's link:Question: When you right-click the DTS package and you choose to schedule the package, how is the owner assigned?Answer: The owner of the SQL Agent job depends on how the SQL Server is registered in the Enterprise Manager. If the SQL Server is registered using a Windows NT authentication, the owner of the scheduled job is the account used to start the SQL Agent service. If the SQL Server is registered in SEM using SQL Server authentication (for example, the SA login), the owner of the job is that same SQL Server login.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
DTS scheduling issues.Urgent help required !