Results 1 to 2 of 2

Thread: Jobs and Steps

  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question Unanswered: Jobs and Steps

    Here is an interesting problem I can't figure out. I have a job with 6 steps as follows:

    Step 1 - Import text file 1
    Step 2 - Import text file 2
    Step 3 - Delete all data from address tables 1 and 2
    Step 4 - Copy data from imported table 1 to address table 1
    Step 5 - Copy data from imported table 2 to address table 2
    Step 6 - Delete imported taxt file table 1 and 2

    Now when I run each of these steps individually, like running the dts packages and stored procedures my self it all works fine and the data in my tables appears to update. Then, when I set the job to run automatically, it says completed and no errors but my data hasn't updated. The job must be doing what it is meant to as it took about 40 seconds which is normal.

    Ever seen this problem before?

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to the KBAs
    http://support.microsoft.com/default...b;EN-US;269074
    http://support.microsoft.com/?kbid=290077
    ... to fix the problem and make sure SQLAgent account has required privileges.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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