Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Help required on scripting


  • Please log in to reply
1 reply to this topic

#1 Mtech21

Mtech21

  • Members
  • 1 posts
  • OFFLINE
  •  
  • Local time:11:31 PM

Posted 16 May 2014 - 03:35 AM

Hi All,

I have a requirement . I have below tables two config tables in SYBASE and one daily status update table. What i need is to write a script to do below.

1) trigger the script corresponds to the Filename once the corresponding groupjos completes

2) but individul jobs shows complete status once the loading completes, however in the background there will be reconciliation going on ..so my script should wait for atleast 15 minutes from the last job in that group completes and then trigger the corresponding script. how can i achieve that.

Please help me as i am new to scripting . Could you please give me sample script from scratch


Config Tables :SCRIPTMAP

 

Filename

scriptname

GROUP-A

groupa.sh

GROUP-B

groupb.sh

 

Config Tables :JOBMAP

Filename Jobs GROUP-A GA_1 GROUP-A GA_2 GROUP-A GA_3 GROUP-B GB_1 GROUP-B GB_2

Another Daily status table tha tupdates the status of jobs everyday for that businessdate

DAILYSTATUS
 

BUSIESSDATE JOB STATUS TIMESTAMP 20140513 GA_1 completed 20140513 23:00 20140513 GA_2 completed 20140514 6:00 20140513 GA_3 completed 20140514 7:00 20140513 GB_1 completed 20140514 3:00 20140513 GB_2 completed 20140514 8:00

Hi All,

I have a requirement . I have below tables two config tables in SYBASE and one daily status update table. What i need is to write a script to do below.

1) trigger the script corresponds to the Filename once the corresponding groupjos completes

2) but individul jobs shows complete status once the loading completes, however in the background there will be reconciliation going on ..so my script should wait for atleast 15 minutes from the last job in that group completes and then trigger the corresponding script. how can i achieve that.

Please help me as i am new to scripting . Could you please give me sample script from scratch

Config Tables :SCRIPTMAP

Filename

scriptname

GROUP-A

groupa.sh

GROUP-B

groupb.sh

Config Tables :JOBMAP

Filename

Jobs

GROUP-A

GA_1

GROUP-A

GA_2

GROUP-A

GA_3

GROUP-B

GB_1

GROUP-B

GB_2


Another Daily status table tha tupdates the status of jobs everyday for that businessdate

DAILYSTATUS

BUSIESSDATE

JOB

STATUS

TIMESTAMP

20140513

GA_1

completed

20140513 23:00

20140513

GA_2

completed

20140514 6:00

20140513

GA_3

completed

20140514 7:00

20140513

GB_1

completed

20140514 3:00

20140513

GB_2

completed

20140514 8:00

 


Edited by Mtech21, 16 May 2014 - 03:38 AM.


BC AdBot (Login to Remove)

 


#2 globalinternethostin

globalinternethostin

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:10:01 AM

Posted 07 June 2014 - 07:51 AM

when you find someone who works for free and is also willing to do your job for you, let us know please- i have a lot of work for them.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users