Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cottage125
Starting Member
32 Posts |
 Posted - 2008-06-18 : 19:26:12
|
| I have a scheduled job to run daily at 4 am. the job imports data from client side from textfiles and puts data in our sql table.It takes around 1 hour. the problem is it doesnt stops after the import process completes.so after one houri can see the data is imported into my sql table so thats fine but the job keeps running.I tried observing that job's spid in activity monitor in sql 2005 but after one hour i cant even seethat spid but still job runs. its weird.and after that when i stop the job manually then it stopssaying job completed succcessfully. that step is a last step and it uses windows cmd.my understanding is the job step doesnt understands that it got finished. what should i do in here?? any ideas r appreciated we are running the same job for another servers and its fine. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 22:32:57
|
| Did you try refresh the job instead? What's job during in job history? |
 |
|
|
cottage125
Starting Member
32 Posts |
Posted - 2008-06-19 : 11:28:55
|
| i refreshed the job but i m thinkning to restart sql agent and in job history i can see "in process" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 17:06:58
|
| Sounds the process didn't disconnect from server properly. How do you load data in the job? |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-21 : 23:34:48
|
| Yes you are correct, You need to restart the Agent if still it did not resolve the issue.ManojMCP, MCTS |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2008-06-22 : 02:28:09
|
| I think you should revisit the job "schedules" tab and check "Daily frequency" section. If that is not set properly then the job can re-execute.What I mean is, if the job schedule is selected "Occure every" given time then this can cause the job to start again once its finished.regardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
|
|
|
job doesnt stop after finish successfully