I have a scenario where i am running a job through sequencer and when the job is being completed it should record the current date and time in the job in two separate columns which are already pre defined.Any ideas or suggestions would be really appreciated.
Regards
Kumar
Passing values to a job through sequencer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Sep 20, 2011 10:44 pm
- Location: INDIA
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
Simple, perhaps, but problematic. Any issues with that approach and you'll be correcting it manually.
You can easily add this "end timestamp capture" function capability into any job that needs it using a Aggregator to ensure that happens last. I'm assuming, however, that you may need to do this for more than a single job. If that's the case, you can build a generic job that gets the end time of any job and populates your table... much like prakashdasika suggested. The "appropriate function" would be DSGetJobInfo() with the DSJ.JOBLASTTIMESTAMP InfoType. Yes, that means you'll need to write a routine and call it from the job to do this, so keep it simple and make it a Server job.
You can easily add this "end timestamp capture" function capability into any job that needs it using a Aggregator to ensure that happens last. I'm assuming, however, that you may need to do this for more than a single job. If that's the case, you can build a generic job that gets the end time of any job and populates your table... much like prakashdasika suggested. The "appropriate function" would be DSGetJobInfo() with the DSJ.JOBLASTTIMESTAMP InfoType. Yes, that means you'll need to write a routine and call it from the job to do this, so keep it simple and make it a Server job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers