Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004

    Unanswered: Help with failing job

    I have an excutable on the c drive and I have created a job to run that excutable

    In the Job
    C:\Folder\job.exe BA

    The job was running until we had a power outage. Now I can get it to run with a scheduled job, the only way I can get it to run is typing it on the command line. I have tried droping and recreating this job but nothing works.

    The error is: The stip did not generate any out put.

    Do I need to troubleshoot the excutable which is a whole other beast.

    Any help would be great.


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    So when you run the program by typing the command at a command prompt, it generates the correct output? I'd be very surprised if that is the case, but I supppose it could happen.

    Where did you find this error message? Was it in the job history, the event log, an application log, or somewhere else?


  3. #3
    Join Date
    Jul 2004
    It was in the JobHistory.

  4. #4
    Join Date
    Jul 2004
    can you try running that step using xp_cmdshell.
    In the Job step change the type to "Transact Sql script" and use
    xp_cmdshell 'C:\Folder\job.exe BA'


  5. #5
    Join Date
    Jun 2003
    Provided Answers: 1
    I bet it is a permissions issue for the service which did not arise until the system was rebooted following the outage.

    What is the SQL Server Agent using as a login?
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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