SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
24x7

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
24x7
Author Message
Sergey G.



Joined: 16 Jan 2000
Posts: 1

Post 24x7 Reply with quote

How to repeat process many times without duplicating script: SQL connection fails, but I want to retry 3 times.

Mon Jun 28, 1999 9:24 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: 24x7 Reply with quote

: How to repeat process many times without duplicating script: SQL connection
: fails, but I want to retry 3 times.

Create 2 jobs of 24x7-script type. First one handles your SQL and creates a semaphore file in notify action on FAIL. Perhaps this job has time-watch schedule. Your second job should have file-watch based schedule and "watch" for the semaphore file created by the first job. When it detects the file it can use JobModify statement to dynamically reschedule your first job. You will also need to put some additional logic into the second job to count number of FAILs. The logic depends on your interpretation of "3 times". It could be for example 3 times today, or 3 times since last successful run or 3 times since Monday or 3 times since last successful database backup or other.

Mon Jun 28, 1999 10:09 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.