Page 1 of 1
Automation of job schedule without director usage
Posted: Tue Jul 24, 2007 7:43 pm
by DSRajesh
Hi
I need to automate the job such that it can shedule the datastage on every month 2nd ..here i am not going use director for scheduling.
How can we do this?
can anybody helps me ?
Posted: Tue Jul 24, 2007 7:59 pm
by DSguru2B
Do you guys have an enterprise scheduler at your site? The scheduling folks should be able to help you out on how to get it done.
Posted: Tue Jul 24, 2007 8:08 pm
by DSRajesh
Hi DSDuru
We dont have enterprise scheduler but can you pls help me how can we achieve this ?
Posted: Tue Jul 24, 2007 9:04 pm
by DSRajesh
can anyone help in this regard
Re: Automation of job schedule without director usage
Posted: Tue Jul 24, 2007 9:45 pm
by kausikMitra
Create shell script(s) which calls the job(s) and keep that in cron.
regards
Kausik
Posted: Tue Jul 24, 2007 9:59 pm
by ArndW
If you use shell scripts and cron then you might as well schedule the jobs in the director, since that is the scheduler used by default in DataStage.
Posted: Tue Jul 24, 2007 11:02 pm
by chulett
The original post is marked as 'Windows' so if that's correct there is no cron. But the point remains, if you run your jobs from the scheduler that DataStage uses, you might as well stick with letting DataStage interface with your scheduler for you.
And if you have nothing in the way of an Enterprise Scheduler... what makes you think you can 'not use Director for scheduling'?
Additionally, why the perceived need to find some other way to schedule this? Director will work just fine...
Posted: Tue Jul 24, 2007 11:46 pm
by ray.wurlod
Actually there are some bugs in the DataStage Windows scheduler interface.
You can submit dsjob commands via AT. Search the forum or manuals for dsjob, and type AT /? for the syntax of the AT command.
Posted: Wed Jul 25, 2007 2:02 am
by rleishman
If you have a one-off non-standard scheduling requirement, you can just schedule it to run every day, and call a Server Routine as the first step in the sequence to work out whether it should run or not.
Then you create a conditional link to the rest of the sequence that only runs when the SR succeeds.
This is not such a hot idea if it is going to be required for a lot of different jobs - it's inelegant and creates a build and maintenance overhead.
Re: Automation of job schedule without director usage
Posted: Thu Jul 26, 2007 5:24 am
by ds_ashish
Hi,
As you are running your datastage on windows then, write one batch program which calls all your executable jobs and schedule it through WINDOWS Schedular.
-------------------------
DSRajesh wrote:Hi
I need to automate the job such that it can shedule the datastage on every month 2nd ..here i am not going use director for scheduling.
How can we do this?
can anybody helps me ?
Re: Automation of job schedule without director usage
Posted: Thu Aug 09, 2007 1:31 pm
by MTA
ds_ashish wrote:Hi,
As you are running your datastage on windows then, write one batch program which calls all your executable jobs and schedule it through WINDOWS Schedular.
-------------------------
DSRajesh wrote:Hi
I need to automate the job such that it can shedule the datastage on every month 2nd ..here i am not going use director for scheduling.
How can we do this?
can anybody helps me ?
WINDOWS Schedular is one among the many best answers