Ending Cognos Scheduler on event occurence 1

[drlex]

Hello all,
Having had a major disk issue over the weekend (the engineers are still downstairs puzzling over the RAID), I'm reconsidering the route taken with Scheduler when the database is down.

At present, the first script to run checks the connection to the database and if there's a problem, it emails me and goes into an infinite loop to prevent the remaining scripts from running. Not very elegant and I'm concerned that it may use processor time (the same server also hosts the cubes in Upfront). I guess I could change it so that it looped for x hours so as to filibuster the subsequent scripts on the 'run x hours after' setting of Scheduler.

Is there a command I can use within a script or a bat file I can shell out to that will terminate Jobmgr32.exe and/or schdl_go.exe?

Many thanks,
lex


soi la, soi carré

 

[GJParker]

Their is a DOS command for this

taskkill /F /IM jobmgr32.exe

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

So I can just bung that in a .bat file and Robert's my mother's brother? T-rific! Serves me right for learning computing pre-DOS...
Thanks Gary.


soi la, soi carré

 

[GJParker]

What a coincidence my aunties husband is also called Robert small world eh!!

glad I could help

Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

Gah!
Now all I need is my server to be upgraded to Win2K3 to use "killtask". Certainly it's not the day to ask the SysAdmin to dig out the Windows 2000 support CD to get a utility installed.
Oi vey!

soi la, soi carré

 

[GJParker]

That's taskkill not killtask make sure you are looking for the correct utility.





Gary Parker
MIS Data Analyst
Manchester, England

 

[drlex]

I was (just c'n'p your post) but mangled my reply. A google on it shows it to be confined to xp or 2k3, with a kill.exe on a 2k tool disk. Anywho, appreciate your help.
lex

soi la, soi carré

 

[drlex]

Sorted!
Couldn't locate the tools disk, so turned the task around.
1. Start server without scheduler
2. Run batch file that calls macro to test DB
> If DB down, email and exit
> If DB up, call batch file to start scheduler and exit


soi la, soi carré

 

[GJParker]

Good thinking Batman !!

The simplest solutions are the best.

Gary Parker
MIS Data Analyst
Manchester, England