SQL Server Performance

DTS Package won't run when scheduled

Discussion in 'SQL Server DTS-Related Questions' started by jim5seven, Nov 19, 2003.

  1. jim5seven New Member

    I have a DTS package in SQL2000 that works fine when I run it manually (Right click-exectue package) but when I schedule it to run it fails every time, at schedule or if i right click-start job same results. Server agent is running, other scheduled jobs are running fine. I am at a loss and would welcome any ideas. I have tried recreating it, making it from the scheduler end...
    Thanks
    Jim Martin
  2. Luis Martin Moderator

    Fails or run for a while and end with errors?


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. jim5seven New Member

    the job Fails right away
  4. Luis Martin Moderator

    Take a look in SQL log and Even Viewer to find error.

    BTW: What SP have you install?

    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  5. jim5seven New Member

    First thank you for your time and effort, I am thankful.

    Running service pack 2

    Error 15457, Severity:0, State:1
  6. Luis Martin Moderator

    Jim:

    According Microsoft errors:
    Configuration option '%ls' changed from %ld to %ld. Run the RECONFIGURE statement to install.

    If this where the razon, run sp_configure from SQL Analyzer and see if there is any value in configured but not running yet.
    If there is something, run RECONFIGURE from SQL Analyzer, and may be you must down and up SQL server.

    BTW: Try to install sp3a






    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  7. satya Moderator

  8. jim5seven New Member

    Thank you for all your help, it turned out to be a securities problem.

Share This Page