What exactly happens during those "in-between" moments. What could be responsible for the time increase? What are fixes can be suggested?
Example:
This is the log of a script ran prior to the upgrade:
Code: Select all
2:55:37 AM 11/18/2011 Control Starting Job EmployeesData. (...)
2:55:37 AM 11/18/2011 Info Environment variable settings: (...)
2:55:41 AM 11/18/2011 RunJob EmployeesData-> (SADetailsExtract): Job run requested(...)
2:55:41 AM 11/18/2011 Info EmployeesData..JobControl (DSRunJob): Wainting for job SADetailsExtract to start
2:55:42 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SADetailsExtract to finish
2:55:45 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job SADetailsExtract finished, status = 1 (Finished OK)
2:55:46 AM 11/18/2011 RunJob EmployeeData-> (SAPostCodeExtract): Job run requested(...)
2:55:46 AM 11/18/2011 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAPostCodeExtract to start
2:55:48 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAPostCodeExtract to finish
2:55:49 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job SAPostCodeExtract finished, status = 1 (Finished OK)
2:55:50 AM 11/18/2011 RunJob EmployeeData-> (SADetailswithContract): Job run requested(...)
2:55:50 AM 11/18/2011 Info EmployeeData..JobControl (DSRunJob): Wainting for job SADetailswithContract to start
2:55:51 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SADetailswithContract to finish
2:55:53 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job SADetailswithContract finished, status = 1 (Finished OK)
2:55:58 AM 11/18/2011 RunJob EmployeeData-> (SAHashFilesFromSP): Job run requested(...)
2:55:58 AM 11/18/2011 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAHashFilesFromSP to start
2:56:00 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAHashFilesFromSP to finish
2:56:01 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job SAHashFilesFromSP finished, status = 1 (Finished OK)
2:56:04 AM 11/18/2011 RunJob EmployeeData-> (HomeLocationHashFileFromSP): Job run requested(...)
2:56:04 AM 11/18/2011 Info EmployeeData..JobControl (DSRunJob): Wainting for job HomeLocationHashFileFromSP to start
2:56:05 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job HomeLocationHashFileFromSP to finish
2:56:07 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job HomeLocationHashFileFromSP finished, status = 1 (Finished OK)
2:56:08 AM 11/18/2011 RunJob EmployeeData-> (SAInsertToSP): Job run requested(...)
2:56:08 AM 11/18/2011 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAInsertToSP to start
2:56:09 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAInsertToSP to finish
2:56:11 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job SAInsertToSP finished, status = 1 (Finished OK)
2:56:12 AM 11/18/2011 RunJob EmployeeData-> (SAUpdateInacEmployee): Job run requested(...)
2:56:12 AM 11/18/2011 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAUpdateInacEmployee to start
2:56:14 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAUpdateInacEmployee to finish
2:56:15 AM 11/18/2011 Info EmployeesData..JobControl (DSWaitForJob): Job SAUpdateInacEmployee finished, status = 1 (Finished OK)
2:56:15 AM 11/18/2011 Control FinishedJOb EmployeesData
Code: Select all
2:49:09 AM 02/18/2012 Control Starting Job EmployeesData. (...)
2:49:09 AM 02/18/2012 Info Environment variable settings: (...)
2:49:56 AM 02/18/2012 RunJob EmployeesData-> (SADetailsExtract): Job run requested(...)
2:49:56 AM 02/18/2012 Info EmployeesData..JobControl (DSRunJob): Wainting for job SADetailsExtract to start
2:49:57 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SADetailsExtract to finish
2:49:59 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job SADetailsExtract finished, status = 1 (Finished OK)
2:50:22 AM 02/18/2012 RunJob EmployeeData-> (SAPostCodeExtract): Job run requested(...)
2:50:22 AM 02/18/2012 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAPostCodeExtract to start
2:50:23 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAPostCodeExtract to finish
2:50:25 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job SAPostCodeExtract finished, status = 1 (Finished OK)
2:50:57 AM 02/18/2012 RunJob EmployeeData-> (SADetailswithContract): Job run requested(...)
2:50:57 AM 02/18/2012 Info EmployeeData..JobControl (DSRunJob): Wainting for job SADetailswithContract to start
2:50:58 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SADetailswithContract to finish
2:51:00 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job SADetailswithContract finished, status = 1 (Finished OK)
2:52:58 AM 02/18/2012 RunJob EmployeeData-> (SAHashFilesFromSP): Job run requested(...)
2:52:58 AM 02/18/2012 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAHashFilesFromSP to start
2:52:59 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAHashFilesFromSP to finish
2:53:01 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job SAHashFilesFromSP finished, status = 1 (Finished OK)
2:54:07 AM 02/18/2012 RunJob EmployeeData-> (HomeLocationHashFileFromSP): Job run requested(...)
2:54:07 AM 02/18/2012 Info EmployeeData..JobControl (DSRunJob): Wainting for job HomeLocationHashFileFromSP to start
2:54:08 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job HomeLocationHashFileFromSP to finish
2:54:10 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job HomeLocationHashFileFromSP finished, status = 1 (Finished OK)
2:54:53 AM 02/18/2012 RunJob EmployeeData-> (SAInsertToSP): Job run requested(...)
2:54:53 AM 02/18/2012 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAInsertToSP to start
2:54:54 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAInsertToSP to finish
2:54:56 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job SAInsertToSP finished, status = 1 (Finished OK)
2:55:29 AM 02/18/2012 RunJob EmployeeData-> (SAUpdateInacEmployee): Job run requested(...)
2:55:29 AM 02/18/2012 Info EmployeeData..JobControl (DSRunJob): Wainting for job SAUpdateInacEmployee to start
2:55:30 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Waiting for job SAUpdateInacEmployee to finish
2:55:32 AM 02/18/2012 Info EmployeesData..JobControl (DSWaitForJob): Job SAUpdateInacEmployee finished, status = 1 (Finished OK)
2:55:32 AM 02/18/2012 Control Finished job EmployeesData