|
We run an overnight process that updates a database with information from a Finance system and this was done using a .NET exe file which is started by Windows Task Scheduler.
The exe file accesses the source DB in read only mode and the target DB in update mode. It runs each database update in the right order and provides log files and emailed error, progress and diagnostic reports.
I know that if the last report has been emailed then all is well otherwise where it fails is in the logs it leaves behind. It does occasionally fail but that is usually following a target db change that has not been fully tested.
|
|
|
|
|
You may check WexFlow or may I suggest you Jenkins ?
|
|
|
|
|
I also agree with using Jenkins and it is free
|
|
|
|
|
Our company uses Jenkins[^].
Builds can run over night, or be initiated at any time.
Jenkins can build out of GitHub, deploy to a VM (for eg.) and report success/failure results to Slack.
Cheers,
Mike Fidler
"I intend to live forever - so far, so good." Steven Wright
"I almost had a psychic girlfriend but she left me before we met." Also Steven Wright
"I'm addicted to placebos. I could quit, but it wouldn't matter." Steven Wright yet again.
|
|
|
|
|
batch files. Kind of. yes sort of. Usually powershell scripts with fairly good transaction processing roll back included that emails successes and failures.
We try to avoid the whole Rube Goldberg Machine setup where if one little thing goes wrong the whole contraption doesn't work.
It does seem to happen once in awhile. What really chafs me is when it is forced on you by the application vendor.
"Oh we have this timer service you setup to run this process. It needs to run this one first and then the second one. It usually takes 15 minutes except when it doesn't. It should be ran at night and no it doesn't email. you just have to manually check it. We recommend setting them to run 2 hours apart. No don't run anything else at that time. Opps sorry that latest patch caused the first one to run for 3 hours. Now everything is messed up. Yes you will need to rerun them during the day. Yes it will be down while this completes. sorry"
Yep, we have had that conversation once. Not fun.
To err is human to really mess up you need a computer
|
|
|
|
|
At work we use a product called "Cybermation" , its formal name is "Enterprise Scheduling System (EPS)". At first I hated it, then I thought, hey, it beats 5,000 tasks, or windows services.
A long term goal I have, is building something like it. The way it works with Active Directory is nice. It puts a small db on the target prod server, and credentials are cached.
In short, something like this is really beneficial, because we have 10's of thousands of jobs running on this.
Informatica is also funneled into this, as well as a lot of other big products.
Where there's smoke, there's a Blue Screen of death.
|
|
|
|
|
At work we use a product called "Cybermation" , its formal name is "Enterprise Scheduling System (EPS)". At first I hated it, then I thought, hey, it beats 5,000 tasks, or windows services.
A long term goal I have, is building something like it. The way it works with Active Directory is nice. It puts a small db on the target prod server, and credentials are cached.
In short, something like this is really beneficial, because we have 10's of thousands of jobs running on this.
Informatica is also funneled into this, as well as a lot of other big products.
Another Scheduling product I see i SKYBOT , it looks more modern.
Where there's smoke, there's a Blue Screen of death.
|
|
|
|
|
I tend to create SQL Server Agent jobs (C# console programs); with a scheduled start.
The "dashboard" works well. Jobs can be any type. Easily restarted.
No agent for the SQL Server Express version though.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
|
|
|
|
|
Hi All,
Used a link on my bar in Chorme this am and got the hamsters eating boards error, tried going through Google and still had rodents eating PCB's. So I think the site could have been down... now its working...
|
|
|
|
|
"Site Bugs/Suggestions" 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I suppose so, but it's working now, my PC is known to have farts where things don't work, I suppose I should make more use of the is it me website...
|
|
|
|
|
It was for a while but, hey! Isn't the hamster picture one of the coolest error messages that you've ever seen?
98.4% of statistics are made up on the spot.
|
|
|
|
|
|
PeejayAdams wrote: Isn't the hamster picture one of the coolest error messages that you've ever seen?
Yes, but I prefer the 404 on CP mode...
Don't look for the page, just try to realize the truth... there is no page
with bob in kimono malforming a spoon.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
glennPattonWork wrote: So I think the site could have been down... now its working...
are you really sure it was up?
are you really sure it was down?
and what if it's only halfway up?
Bonus question:
what does a cat think about when it's inside a box?
This internet thing is amazing! Letting people use it: worst idea ever!
|
|
|
|
|
Lopatir wrote: are you really sure it was up?
are you really sure it was down?
and what if it's only halfway up?
It is up, and it is u̅p̅ 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
As any British schoolchild could tell you:
"When they were up they were up,
And when they were down they were down,
And when they were only half-way up,
Their trousers all fell down."
The Grand Old Duke of York - Wikipedia[^] 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
I'm still waiting to hear what happened here. Basically our Redis server went into an unstable state (kinda fits our current mood, really). It was soundly kicked and we're back in business.
The thing that really irks us is the monitoring systems were all saying Life's Goodtm.
cheers
Chris Maunder
|
|
|
|
|
Create improvised movement (9)
... such stuff as dreams are made on
modified 6-Jun-18 6:01am.
|
|
|
|
|
MAKESHIFT?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Bingo!
... such stuff as dreams are made on
|
|
|
|
|
And CP is back as well! Yay!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
The latest move by Microsoft to purchase GITHub in an all-stock offer is making rounds on the headlines. Is it good for Microsoft or GitHub? Would open source be challenged by proprietary software?
|
|
|
|
|
Lesley[^] got there before you.
Twice.[^]
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
