Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    123

    Unanswered: How to start DTS in job

    Hi,

    Maybe a stupid question, but how do I start a DTS in a job?

    I have to write some kind of command in a step to get the DTS started.
    Can't figure out how...

    The reason behind this is that I have sql-server database and an Access project as a frontend. I want to be able to start the DTS from the frontend via a stored procedure that uses sp_start_job to run a job that runs the DTS. Is this a bad idea?

    The DTS imports a textfile weekly on a schedule but i want the users to be able to import the file att anytime also istead of having me do it for them.

    Any ideas?

  2. #2
    Join Date
    Jul 2003
    Posts
    123
    I've solved the problem...

  3. #3
    Join Date
    Jul 2003
    Posts
    123
    Now I have another problem... :-)

    When i try to run this stored procedure:

    CREATE PROCEDURE ProcImportConFile AS
    EXEC msdb.sp_start_job @job_name = 'Import_file'
    GO

    I get the this message in my Access Project frontend:
    "Could not find stored procedure 'msdb.sp_start_job' "

    How do I get to the sp_start_job?

  4. #4
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by oneleg_theone
    Now I have another problem... :-)

    When i try to run this stored procedure:

    CREATE PROCEDURE ProcImportConFile AS
    EXEC msdb.sp_start_job @job_name = 'Import_file'
    GO

    I get the this message in my Access Project frontend:
    "Could not find stored procedure 'msdb.sp_start_job' "

    How do I get to the sp_start_job?
    You did not set the owner of sp:

    CREATE PROCEDURE ProcImportConFile AS
    EXEC msdb.dbo.sp_start_job @job_name = 'Import_file'
    GO

Posting Permissions

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