Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Agent : Job Failure


SQL Server Agent : Job Failure

Author
Message
elhelalaoui
elhelalaoui
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 103
Hello,
I wish to put the result of a query in Excel then send it to a number of persons at a specified moment. I've started by the configuration of all this on a SSIS package, till then everything is all right, all steps are going well. The problem appears when I tri to schedule this work via the SQL Server Agent.. You'll find below the steps i've done :

1- On the general part, I name the job and put the account sa as owner.
2- On the Steps part, i create a new step and then I set :
2.1 the name of the step.
2.2 Run AS = SQL Agent Service Account
2.3 On the general tab, I put the source of the package as a System File, I browse the package, then i save all.

When I tri to execute the Job, I receive this error (On job history) : "The JOB Failed. The Job was Invoked by user NomDuServeur\Administrateur. The last step to run was Step 1." ==> "Executed as user : MonDomaine\Système. The package executon failed. The step failed." :|

FYI : I'm using SQL Server 2005 with the OS Windows Server 2008 R2 64bit.

Could you help please ?

Thanks and regards.
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2873 Visits: 2235
There are two approach:

one is you can use notification feature of the job to send e-mail notification when job completes i.e. success or failure.

Second is you periodically check the job history table in MSDB database to send result via e-mail attachment.

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
elhelalaoui
elhelalaoui
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 103
Thanks free_mascot.
The problem is that all my jobs never succeed Crying
Do you have any idea about that error ? :-)
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2873 Visits: 2235
Check the permission. Is there any permission issue? All jobs are failing with same error?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
Create a credential with your ID and a SSIS agent proxy with that credential. Then run the job using that credential.

http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

--
SQLBuddy
elhelalaoui
elhelalaoui
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 103
Thanks free_mascot, thanks sqlbuddy123. All my jobs are going with the same error.
I've just tried the solution of the proxy, and getting this error now : Could not get proxy data for proxy_id = 10 Exclamation Mark
Please help Crying I'm executing all my packages manually everyday Sick
Thanks :-)
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
elhelalaoui (3/26/2014)
Thanks free_mascot, thanks sqlbuddy123. All my jobs are going with the same error.
I've just tried the solution of the proxy, and getting this error now : Could not get proxy data for proxy_id = 10 Exclamation Mark
Please help Crying I'm executing all my packages manually everyday Sick
Thanks :-)


Change the job owner to SQL Agent Service account or your ID and run it. Lets try that ..

--
SQLBuddy
elhelalaoui
elhelalaoui
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 103
It Doesn't working, I'm getting the first error now Sad
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
elhelalaoui (3/27/2014)
It Doesn't working, I'm getting the first error now Sad


Did you run it like this ...

Change the job owner to SQL Agent Service account or your ID and run the job step as SSIS Proxy that you created before.

--
SQLBuddy
elhelalaoui
elhelalaoui
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 103
I'm still having this error : Could not get proxy data for proxy_id = 11
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search