SQL Server Agent : Job Failure

Question

SQL Server Agent : Job Failure

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

elhelalaoui Right there with Babe Points: 766 More actions · Answer 1

1- The proxy i created is based on a credential attached to my local admin account, wich have full access to my databases.

2- The Protection level of the package is on "DontSaveSensitive".

3- In the Job history I'm getting only the errors above 🙁

elhelalaoui Right there with Babe Points: 766 More actions · Answer 2

elhelalaoui

Right there with Babe

Points: 766

April 12, 2014 at 8:50 am

#1705539

Is there any hope to resolve this issue ? :unsure:

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

First try running the job using and see if it works then we can schedule it as a job ..

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_Name' ;

GO

--

SQLBuddy

elhelalaoui Right there with Babe Points: 766 More actions · Answer 4

Hello,

Sorry for the delay, I had personal difficulties so I could'nt do this test.

I've just launched that query and it appears that it goes well (Message : Job 'Test' started successfully.), but no email was generated :ermm:

Must I du something else ?

Thanks. 🙂

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

elhelalaoui (5/5/2014)
Hello,
Sorry for the delay, I had personal difficulties so I could'nt do this test.
I've just launched that query and it appears that it goes well (Message : Job 'Test' started successfully.), but no email was generated :ermm:
Must I du something else ?
Thanks. 🙂

Create a job and within a TSQL Job step use this command

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_Name' ;

GO

Let the job run under your account i.e Owner of the job ..

--

SQLBuddy

elhelalaoui Right there with Babe Points: 766 More actions · Answer 6

Do you mean that I must create 2 step in one JOB ?

1st Step witch contains that command.

Second step with the SSIS package.

Thanks.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 7

elhelalaoui (5/12/2014)
Do you mean that I must create 2 step in one JOB ?
1st Step witch contains that command.
Second step with the SSIS package.
Thanks.

No just one step. You already have a Job for SSIS package that you have been running manually. Lets say its JOBA.

In the new job, just use that command with JOBA in it.

--

SQLBuddy

elhelalaoui Right there with Babe Points: 766 More actions · Answer 8

Excuse me but could you show me the methode please ?

I'm still not able to create that second Job