on 09-27-2016 5:24 AM
Hi All,
The job hang without error. I have a job as daily schedule. The actually time running of this job is usual 2 or 3 mins. But today job is running 30 mins and still running mode.
Please suggest anyone please
Thanks
Murali
Hi Murali,
Kill/abort the job and trying reruning the job.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It's possible there is a long-running operation/query in the database from your job (or another) that is masquerading in DS as being stuck. Have your DBA trace the session from your Job Server on the database to find out what it's doing. And/or try running the SQL from your transform directly against the database and check the result. It's possible the table statistics are stale, or the execution plan changed and now the SQL is not running as efficiently as before.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.