Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
The controlling job can be scheduled to run once per day, exiting after it has processed 23 hours and 45 minutes worth of runs. This gets around the sleeping issue to some extent. It could also wake every minute or so to check whether it has been notified to terminate.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 07:34
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 07:34
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
Ray,
I seem to recall you or someone mentioning that there is a way for job control code to detect if a stop request has been issued. Can you provide more info on this?
Thanks,
David
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, 15 November 2001 7:39 AM
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
The controlling job can be scheduled to run once per day, exiting after it has processed 23 hours and 45 minutes worth of runs. This gets around the sleeping issue to some extent. It could also wake every minute or so to check whether it has been notified to terminate.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 07:34
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
I seem to recall you or someone mentioning that there is a way for job control code to detect if a stop request has been issued. Can you provide more info on this?
Thanks,
David
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, 15 November 2001 7:39 AM
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
The controlling job can be scheduled to run once per day, exiting after it has processed 23 hours and 45 minutes worth of runs. This gets around the sleeping issue to some extent. It could also wake every minute or so to check whether it has been notified to terminate.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 07:34
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
Im not in a position to respond with manual references this week. IIRC a stop request (for example DSStopJob) updates a field in the RT_STATUSmm file for the job. This value, which represents a pending stop request, can be interrogated by the jobs controller if desired.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 09:28
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Ray,
I seem to recall you or someone mentioning that there is a way for job control code to detect if a stop request has been issued. Can you provide more info on this?
Thanks,
David
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, 15 November 2001 7:39 AM
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
The controlling job can be scheduled to run once per day, exiting after it has processed 23 hours and 45 minutes worth of runs. This gets around the sleeping issue to some extent. It could also wake every minute or so to check whether it has been notified to terminate.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 07:34
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 09:28
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Ray,
I seem to recall you or someone mentioning that there is a way for job control code to detect if a stop request has been issued. Can you provide more info on this?
Thanks,
David
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Thursday, 15 November 2001 7:39 AM
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
The controlling job can be scheduled to run once per day, exiting after it has processed 23 hours and 45 minutes worth of runs. This gets around the sleeping issue to some extent. It could also wake every minute or so to check whether it has been notified to terminate.
-----Original Message-----
From: David Barham [mailto:david@barham.hm]
Sent: Thursday, 15 November 2001 07:34
To: datastage-users@oliver.com
Subject: RE: Job Scheduling
Id write another job to run your job.
Have a loop which runs the job, waits for it to finish, calculate how much of the 15 minutes is left and then sleep that long.
Depending on your version of DataStage, stopping this job may be an issue. You might want to provide parameters which determine how long this job continues looping for. Another option is to query a database table or a file or something to provide you with a way of telling it to stop whenever you want.
Earlier versions of DataStage would not respond to a stop request while the job is sleeping. Someone was suggesting that this is not the case in more recent versions, but I have not yet tried this myself , nor do I know at which version this might have changed.
-----Original Message-----
From: Carol.Gorrie@NOSWA.CO.UK [mailto:Carol.Gorrie@NOSWA.CO.UK]
Sent: Thursday, 15 November 2001 2:23 AM
To: datastage-users@oliver.com
Subject: Job Scheduling
Hi everyone,
Could someone tell me how to schedule a job to run every (say) 15 minutes. Thanks, Carol
________________________________________
North of Scotland Water Authority
http://www.noswa.co.uk
Telephone: 0845 743 7437
NOTE: Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail. This e-mail and any attachments are believed to be virus free but no responsibility is accepted for loss or damage arising in any way from receipt or use thereof. Opinions, conclusions and other information in this message that do not relate to the official business of the North of Scotland Water Authority shall be understood as neither given nor endorsed by it.