SQL Server Performance

Question on Job Schedule

Discussion in 'SQL Server 2005 Integration Services' started by linus516, Jul 18, 2007.

  1. linus516 New Member

    Hi All,

    I encounter the following problem :

    I create a SSIS in VS2005, it can run successfully in there.

    then i save the package into Server, and execute it. It still can be run successfully

    then i make a job which run this package regularly, it run failure. Even I start the job manually, it also fail.

    this is the message:
    Date7/18/2007 5:41:24 PM
    LogJob History (a)

    Step ID1
    ServerHITSQL034
    Job Namea
    Step Name1
    Duration00:00:27
    Sql Severity0
    Sql Message ID0
    Operator Emailed
    Operator Net sent
    Operator Paged
    Retries Attempted0

    Message
    Executed as user: HITDOM00OICSQLAG. The package execution failed. The step failed.

    I guess this is due to the Job Agent. But dont know how can i set it

    Thanks,
    Linus
  2. ranjitjain New Member

    Hi,
    I feel there must be some permission issues.
    Log says that job actually ran for 27 seconds which means it must have started the package.
    Start the job manually and check under running packages in integration service.
    This will imply whether the package actually gets executed by job or not.
    Also have you specified any configuration files.
  3. linus516 New Member

    where can i set the permission for that?
  4. satya Moderator

    What are the privileges for the SQLAgent service account on SQL Server?
    You can edit that job to run under SA account or your account to continue without any issues.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page