none
The job failed. The job was invoked by user<user>. The last step to run was step. RRS feed

  • Question

  •  

    Hi,

    I have an error, when I started job. I used CmdExec job step type.

     

    they are error logs.

     

    Date  12/12/2007 1:58:14 PM
    Log  Job History (pom_job)

    Date  12/12/2007 2:06:41 PM
    Log  Job History (pom_job)

    Step ID  0
    Server  PHILIP-KL030JOW
    Job Name  pom_job
    Step Name  (Job outcome)
    Duration  00:00:00
    Sql Severity  0
    Sql Message ID  0
    Operator Emailed  
    Operator Net sent  
    Operator Paged  
    Retries Attempted  0

    Message
    The job failed.  The Job was invoked by User PHILIP-KL030JOW\pom_login.  The last step to run was step 1 (r).

     

    ---------------------------


    Date  12/12/2007 2:06:41 PM
    Log  Job History (pom_job)

    Step ID  1
    Server  PHILIP-KL030JOW
    Job Name  pom_job
    Step Name  r
    Duration  00:00:00
    Sql Severity  0
    Sql Message ID  0
    Operator Emailed  
    Operator Net sent  
    Operator Paged  
    Retries Attempted  0

    Message
    Executed as user: PHILIP-KL030JOW\pom_login. The step did not generate any output.  Process Exit Code 0.  The step failed.

    Wednesday, December 12, 2007 9:31 AM

Answers

  • Hi all,

    I had the same issue with MSSQL 2008

    The issue seems to been solved after installing the SP1

    If anyone still has this issue just give it a try and let the people here know if that solved your issue.

     

    Wednesday, June 9, 2010 6:46 AM

All replies

  • What does this Step in Job do? Coluld you check this step (go to property --> Steps) and run the script in QA

     

    Madhu

    Wednesday, December 12, 2007 10:22 AM
    Moderator
  • Can you pls enable logging option i.e create an output text file so that next time the job runs it will write to the text file. Double click the job step and go to advanced tab and provide a path and name of the text file in ' Output File '.

    - Deepak

    Wednesday, December 12, 2007 1:14 PM
    Moderator
  •  

    I created an output file of this job in c:\test.txt. It has no any data in log file.

     

    This is a command in a bat file. I executed it, it success in command prompt.

     

     cd /D C:\Program Files\Microsoft SQL Server\MSSQL\BINN

     SET Failed=0

     sqlmaint.exe -D LRF -S localhost -VrfyBackup -BkUpMedia DISK -BkUpDB "H:\Backup" -DelBkUps 1DAYS -CrBkSubDir -BkExt "BAK"
    IF %ERRORLEVEL% NEQ 0 (SET Failed=1)

     EXIT %Failed%

     

     

    The version of SQL Server is MS SQL Server 2005 and I created proxies user using sysadmin  for run this job.

     

    Thanks ,

     

    Nithid

    Thursday, December 13, 2007 5:10 AM
  • Hi,

     

    You need to use double quotes in between the path as below

    cd /D "C:\Program Files\Microsoft SQL Server\MSSQL\BINN"

    Friday, December 14, 2007 12:22 AM
    Moderator
  •  Vidhya Sagar wrote:

    Hi,

     

    You need to use double quotes in between the path as below

    cd /D "C:\Program Files\Microsoft SQL Server\MSSQL\BINN"

     

    I did by this solution, but it did not success.

    Thanks

     

    Saturday, December 15, 2007 12:44 AM
  • I could do. I put the path of bat file to the command box, I don't use open botton.

    Monday, December 17, 2007 8:43 AM
    • Does sqlagent service account have read and execute privilege in the path C:\Program Files\Microsoft SQL Server\MSSQL\BINN"??
    • In the job step have you seleted operating system command in the type drop down menu??
    Thursday, December 20, 2007 2:26 AM
    Moderator
  • hi frinds
    i have same problem but it's about user logins

    in output file i have

    DTSRun:  Loading...

    DTSRun:  Executing...

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_1

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_2

    DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)

       Error string:  Login failed for user 'philip'. Reason: Not associated with a trusted SQL Server connection.

       Error source:  Microsoft OLE DB Provider for SQL Server

       Help file: 

       Help context:  0

     

    Error Detail Records:

     

    Error:  -2147467259 (80004005); Provider Error:  18452 (4814)

       Error string:  Login failed for user 'philip'. Reason: Not associated with a trusted SQL Server connection.

       Error source:  Microsoft OLE DB Provider for SQL Server

       Help file: 

       Help context:  0

     

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1

    DTSRun OnError:  DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005)

       Error string:  Login failed for user 'philip'. Reason: Not associated with a trusted SQL Server connection.

       Error source:  Microsoft OLE DB Provider for SQL Server

       Help file: 

       Help context:  0

     

    Error Detail Records:

     

    Error:  -2147467259 (80004005); Provider Error:  18452 (4814)

       Error string:  Login failed for user 'philip'. Reason: Not associated with a trusted SQL Server connection.

       Error source:  Microsoft OLE DB Provider for SQL Server

       Help file: 

       Help context:  0

     

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_2

    DTSRun:  Package execution complete.
    //////////////////////////////////////
    I dont have 'Sa' password but the 'philip' user is administrator of my server 

    can any one help me to solve this problem??

    Saturday, September 26, 2009 9:31 AM
  • Error:  -2147467259 (80004005); Provider Error:  18452 (4814)

       Error string:  Login failed for user 'philip'. Reason: Not associated with a trusted SQL Server connection.

       //////////////////////////////////////
    I dont have 'Sa' password but the 'philip' user is administrator of my server 

    can any one help me to solve this problem??


    Is the server configured for MIXED authentication?

    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
    Tuesday, October 27, 2009 9:28 AM
    Answerer
  • yes it MIXED
    Tuesday, November 3, 2009 6:40 AM
  • Have you restarted the SQL services after setting Mixed authentication?
    Are you able to login to the server using philip ID using SSMS or other client tools?
    Vidhya Sagar. Mark as Answer if it helps!
    Wednesday, November 4, 2009 3:21 AM
    Moderator
  • YEs i can Login And i can do every thing Also i Can Run that job manually but when i run it under scheduled it's fail
    Thursday, March 11, 2010 10:09 AM
  • Hi all,

    I had the same issue with MSSQL 2008

    The issue seems to been solved after installing the SP1

    If anyone still has this issue just give it a try and let the people here know if that solved your issue.

     

    Wednesday, June 9, 2010 6:46 AM

  • I have already installed SP1, but still the issue persists. Any further solutions for this.
    Sunday, October 3, 2010 6:20 PM
  • Hi Kalman,

    I got a this issue "The job failed.  The Job was invoked by Schedule 48 (Every 5 min).  The last step to run was step 1 (Run)". how can i overcome this?  if easily overcome this where should we do, you mentioned SP1 means (Service Pack 1) right?,we got a mail from technical support team.so,please help me .

    Advance Thank you,

    Regards,

    Rajashekar.

    Friday, May 17, 2019 9:42 AM