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

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.

Answer 1

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

 

Madhu

Answer 2

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

Answer 3

 

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

Answer 4

Hi,

 

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

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

Answer 5

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

 

Answer 6

I could do. I put the path of bat file to the command box, I don't use open botton.

Answer 7

• 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??

Answer 8

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??

Answer 9

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 & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com

Answer 10

yes it MIXED

Answer 11

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!