Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automation of jobs processing

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
hi All
i want to know whether there is any way to delay
a report(Sybase based)processing up to a specific period of time...i.e if the user submit his report in daytime still
the report processing by RS6k start in the late night.
All ideas will be highly appreciable.

regds
Anand
 
Hi Anand,

Have you thought about writing a "wrapper" shell script that would submit the Sybase job to run at a particular using time using the 'at' command?
Mike
michael.j.lacey@ntlworld.com
 
hi mike
Thanks for your response.
I dont know about "wrapper" script....which you
are referencing.
Can you explain your idea more explicitly..

Regds
Anand
 
I'm not a Sybase person but I would imagine that there is a command that runs a Sybase report. I suggest that you write a shell script that submits the Sybase command using the unix command 'at'.
Mike
michael.j.lacey@ntlworld.com
 
hi
If there is any command in sybase to start the report
(as mike imagine it) then there will be no problem
but if there is no such command (as in most of databases
e.g in oracle)then it is difficult to handle the situation.
Probably you have to consider the automation by the user's
process(PID).....just an idea.
Changing the priority of user process (by nice command )
may aslo be one solution.

regds
Shiraz
To Every Problem There is a solution...........
 
In Oracle you can submit a job to the database itself, is that possible using Sybase?
Mike
michael.j.lacey@ntlworld.com
 
hi
Infact we are running both databases (sybase as well oracle
on two RS6k boxes......and machine response become very low
when users run their reports.
while talking about oracle..Mike can you explain me
further that how we can "submit jobs to database itself"
or i go to oracle forum and ask that thing there.

Regds
Sunil
 
Hi Sunil,

Probably better that you ask the question in the Oracle forum but, briefly, you create a database procedure and put a job in the job queue that will call that procedure at the right time. For reports it's quite common to have a procedure that drags a lot of information together before the report is run, the report can then just read a single table an run quite quickly - the "dragging" procedure would be the thing put in the job queue.
Mike
michael.j.lacey@ntlworld.com
 
hi all
Infact i have asked that question in oracle forums.....
So probably i will get the answer from there very soon.
For Elgis! i don't know the command...user enter the
Xwindows environment and click the run button.....and that's
it.
Hope to have some solution from you guys b/c workload
management is a common problem...and by the way AIX4.3
claims to support workload management up to greater extent
as compared to AIX4.2...can it help "really" in this regard
(we have aix4.2.1 here in our env.)


Sunil
To Every Problem There is a solution...........
 
sorry to all folks....
i must make this thing clear that due to some security
reasons (esp. according to my company policy i can't
mention any thing! not even environment ...so that's why
i asked that question as a visitor.
i hope that you all folks will never mind that.
And now returning to the problem solution.....i have struck with a new idea which is that if i stop the user's process
anyhow and later start his process with continue signal then
whether it will work?Any ideas...
I think one way to stop the user process is Crtl-Z key
combination.....

Shiraz To Every Problem There is a solution...........
 
If you want to process the job at perticular time you can do that by using at command

at 6 PM today
<filename>
ctl-d

we have written one shell script to run the job daily at 6PM. we submitted above
command. for every run it automatically schedule the job for the next day 6PM.
in that shell scprit you have to include following .

if [ `date +%w` -eq 5 ]
then
echo &quot;ksh $0 &quot; | at now + 3 days
else
echo &quot;ksh $0&quot; | at now + 1 day
fi
 
If you want to STOP (pause) a program just send a [tt]kill -18 PidOfProgram[/tt]... that signal can't be catched or ignored, and, whenever you want to unpause it, simply send to it a [tt]kill -19 PidOfProgram[/tt].

You can create a little script to find the needed pid...

Ah! Try [tt]kill -l[/tt] to see the available signals and their simbolic names.

I hope it works...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top