Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Unanswered: Executing App with DTS, trouble with scheduling package

    Hello,

    I've created a test application in windows ( vb.net ). When executing this app with the DTS package it seems to work fine ( by right clicking on the package and selecting “Execute Package” ). It finishes successfully and does what it supposed to. But when I try to schedule the package with the SQL Server Enterprise Manager in Management > SQL Server Agent > Jobs it Fails every time. I schedule it by right clicking on the package and selecting the “Schedule Package” option. Does any one have an idea why the schedule keeps on failing? Thanks in advance.

    Daniel B

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    1) Locate the job (under SQL Agent)
    2) Right click on the job
    3) Pick View Job History...
    4) Check the Show Job Details box
    5) Read the error message(s)

    -PatP

  3. #3
    Join Date
    Nov 2004
    Posts
    3
    This is the error message i get.

    The job failed. The Job was invoked by User REPEATSEAT\dberezniak. The last step to run was step 1 (DTS Execute App).

    This doesn't tell me much. It blows up when trying to execute the app.
    ( The application is test and does work on its own and within the package. )

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Did you click on the "Show Job Details" box to be sure that it is checked? That message sounds like what you'd get if that box wasn't checked.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •