Results 1 to 6 of 6
  1. #1
    Join Date
    May 2010
    Posts
    3

    Unanswered: Sql procedure not executing

    I have an ETL job created which has a step which executes a sql procedure on sql server 2005.
    The step shows complete after a while , but when I look into the DB , none of the sql statements in the procedure have executed.
    Did anyone encounter this issue?
    Any suggestions to get around this would help us a lot.

  2. #2
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    I think you are going to have to show us the stored procedure.

    Also, myself being a beginner, what does ETL stand for?
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    More information required.

    Is this a standard SQL Job? If so, what's the definition.
    What's the sproc definitions and how do you know they are not executing?
    George
    Home | Blog

  4. #4
    Join Date
    May 2010
    Posts
    3
    I am executing this procedure using SAP datservices ETL tool.
    I have one step withing the package which executes this procedure.
    Yes this is a standard proc, I have setup audit entries within in procedure which after certain steps will update the audit table to say ***completed datamart load*** for example.
    This was running fine for months and suddenly this started to happen.
    Not sure why a proc will not run?

  5. #5
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    I would start with the standard troubleshooting steps:

    Review the connection string of the report
    Review the ETL tool error log
    Review the SQL Server error log
    Setup a SQL Profiler trace and see if the commands are actually executed against the db
    etc.

  6. #6
    Join Date
    May 2010
    Posts
    3
    The procedure is sending a success message to the ETL step.
    There are no erros in ETL or sql server.

Posting Permissions

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