Post reply

DTS Problem

  • April 25, 2002 at 8:41 am

    #101132

    Hello,

    I've got a problem with Sheduling a Data Transformation Package. I can execute it at will with no problems (it's a fairly simple package), but I want it to run at 9:00 am every morning. I can see how this is done with the Sheduling option, but it doesn't do what it's supposed to. What's odd is every time I go to set it it has re-set the options to Daily at 00:00. Has anyone else had this problem ?

    Any ideas would be gratefully recieved

    James

  • April 25, 2002 at 9:08 am

    #427848

    So let me make sure I understand properly. When you open the job created to perform the scheduled task (which is in SQL Agent/Jobs) the jobs schedule is 00:00 daily. Or are you opening schedule job again and seeing the default time in there for the new schedule which it is assuming.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • April 25, 2002 at 9:26 am

    #427851

    Yeah, I've been testing it and trying to get it to execute about 10 minutes later, but it doesn't happen. When I go back to set a new time and test again the time has always reverted to 00:00. I don't know if that in itself is a problem or wether it just re-sets as a matter of course. It just doesn't seem to do it at all unless I execute it manually.

  • April 25, 2002 at 9:51 am

    #427854

    Ok, when you do schedule job it will always be 00:00 daily by default. However if you go into SQL Agent and jobs unless your jobs were defined to delete themselves they should still be there. Just open one and look at the time and adjust there. Otherwise create a scheduled job one and goto the job making sure not set to delete itself and afix a one time only time to run in 10 mintues and adjust/enable it each time you need to.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • April 25, 2002 at 10:20 am

    #427859

    Ahh ha, I think it's a simple matter of permissions, when I go to the Jobs bit I get a permission denied message on thesp_get_sqlagent_properties' object. I'm trying to get this rectified, thanks for your help you've pointed me in the right direction 🙂

  • April 25, 2002 at 11:52 am

    #427869

    I think with my cofussion on what you were saying that was an accident.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply