Timeline for sql agent job hangs without any errors or warnings [closed]
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 29, 2015 at 7:03 | history | closed |
Hannah Vernon♦ Philᵀᴹ mustaccio RLF user507 |
Not suitable for this site | |
| Nov 27, 2015 at 23:26 | review | Close votes | |||
| Nov 29, 2015 at 7:03 | |||||
| Jan 22, 2015 at 11:36 | history | edited | user1822 |
edited tags
|
|
| Jan 22, 2015 at 11:20 | answer | added | WoodyStory | timeline score: 0 | |
| Jan 22, 2013 at 1:56 | comment | added | oOo Testing1 oOo | hi mrdenny!! the query is executed against oracle server when it hangs!! I didn't know about wait types... i will check wait types now when it hangs... thanks | |
| Jan 22, 2013 at 1:49 | comment | added | oOo Testing1 oOo | hi nazila!! we don't have call to xp_cmdshell in our job. I guess "it is possible that i am are trying to use a resource that is not available at time of running". The user set up to run the job have all the required rights(Administrator). I have to check wait type. Thanks for your time | |
| Jan 21, 2013 at 19:19 | comment | added | mrdenny | What's the wait type of the running process in the SQL Server? Is the query from the SSIS package being executed against the Oracle server when it "hangs"? | |
| Jan 20, 2013 at 1:06 | comment | added | Sky | Sorry, I was typing the comments above from my mobile and made mistakes, which the forum did not let me to delete or edit them after 5 minutes. Do you have call of xp_cmdshell in your job? Is it possible that you are trying to use a resource that is not available at time of running Or the user you have set up to run the job (scheduled) does not have the required rights to access the resource? Also what is the wait type in your ssis package? Is it PREEMPTIVE_OS_PIPEOPS? If so, please check the link below: sqlservercentral.com/Forums/Topic802987-110-1.aspx#bm1339542 The links below al | |
| Jan 20, 2013 at 0:48 | comment | added | Sky | Do you call of xp_cmdshell in your job? What is the wait type in your ssis package? The links below might be helpful: | |
| Jan 18, 2013 at 21:43 | history | asked | oOo Testing1 oOo | CC BY-SA 3.0 |