SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Can I schedule?

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Can I schedule?
Author Message
Caren Margolin



Joined: 28 Jun 1999
Posts: 2

Post Can I schedule? Reply with quote

My company has 57 offices all over the US networked. I would like to notify local administrators about different processes related to their local server database. Can I schedule email messages, or reminders across the states and attach needed files to them - for example, ini file, or sql statement to be ran before the database backup? Thanks

Mon Jun 28, 1999 12:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Re: Can I schedule? Reply with quote

Are these processes centralized or you kick them off independently in each office?

: My company has 57 offices all over the US networked. I would like to notify
: local administrators about different processes related to their local
: server database. Can I schedule email messages, or reminders across the
: states and attach needed files to them - for example, ini file, or sql
: statement to be ran before the database backup? Thanks

Mon Jun 28, 1999 12:51 pm View user's profile Send private message
Caren Margolin



Joined: 28 Jun 1999
Posts: 2

Post Re: Can I schedule? Reply with quote

: Are these processes centralized or you kick them off independently in each
: office?

Yes, I want to centralize them.

Mon Jun 28, 1999 6:40 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6502

Post Re: Can I schedule? Reply with quote

: Yes, I want to centralize them.

There are two possible scenarios:

a) You have a separate job for every office. For every office bound job create another "notify" job of script type that runs 15 minutes before the main one and all it does it calls MailSend statement to notify the correct office admin of upcoming main job. The advantage of doing this is that these jobs can simultaneously. The main disadvantage that you have to create and maintain 2*57 jobs.

b) You have one big job of script type that sequentially does something for each office. In that job for every office you have to call MailSend first than call Wait 15 minutes than call Run (or whatever). Therefore, you have just one job but that job will run at least 15*57 minutes (22 hours). It does not sound like a good option but guarantees sequentially execution. The script itself can be setup as asynchronous so that it does not prevent other jobs from running.

Tue Jun 29, 1999 9:48 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.