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 |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-01-13 : 21:51:10
|
| I AM RUNNING A JOB IN SSMS 2008 ON EVERY DAYI CREATED THAT JOBS SSIS PACKAGES IN THAT SSIS PACKAGES INCLUDED FULL AND INCREMENTAL DATA AND CREATE AND REBUILD INDEXES AND PACKAGEUPADATIONS AND INSIDE THAT PACKGES DATAFLOW TASK TABLES THERE.I WANT TO KNOW THE HOW MANY TASKS ARE EXECUTED AND WHICH TASK IS RUNNING PROPERLY SEQUENCE CONTAINER --->EXECUTESQL TASK------>DATAFLOWTASK--->SEQUENCE CONTAINER ----> WHEN EVER I AM RUNNING THESE SSIS PACKAGE THROUGH JOB I NEED TO KNOW THE STATUS OF WHICH TASK IS CURRENTLY RUNNINGCAN ANYBODY KNOWS HELP ME |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-13 : 23:51:31
|
| you need to either enable logging in package or add a custom logging table where you can manually log the task statuses using event handlers------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
JOB STATUS