Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Check for end of job

    Hi everyone,

    I'm quite a newbie to SQL and DTS and I need your help!
    HTe situation:
    I've got an Access97 frontend with an SQL7 backend. On the SQL-server I created a job (to execute a DTS package) which is triggered by a custom-error. From the Access-side I raise this error to start excuting the DTS. I do that this way: execute master..xp_logevent 50001, LOG

    This works fine, the job runs and everything, however I need to know when the job has ended. The code that is after this call in Access97 needs to be sure that the DTS-package has finished executing.

    How do I do that, please bear in mind that I'm quite a newbie so simple language please

    TIA, Raymond

  2. #2
    Join Date
    Sep 2003
    New York, NY
    May be the last step in DTS populates a field in some table, and your Access 97 front end keeps checking that table to see if that field has been updated or not.

Posting Permissions

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