Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Weber Stefan  
#1 Posted : Tuesday, September 8, 2015 9:26:08 AM(UTC)
Weber Stefan
Rank: Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 7

We have many jobs in Targit which send reports to users early in the morning.
Sometimes the preparing job on the SQL-Server fails and the reports are then not up to date.
My question:
Is there an idea how we can stop the Targit scheduled jobs if the job on SQL-Server didn't run?
So we could avoid that wrong data are sent to users.

Thanks for any advices!

Best regards
Peter Bagger  
#2 Posted : Friday, December 4, 2015 1:09:02 PM(UTC)
Peter Bagger
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/7/2015(UTC)
Posts: 12

Hi Stefan,

I have the same problem and have been hoping for a better reply than I can give you.

I have 2 issues
A) The job sometimes fails.
B) Sometimes the job hasn't finished before sending emails.

I have made the following work around:

1. Instead of sending a lot of emails every day I upload the reports to a folder every 5 minutes from 6 - 10 am.
2. When the system is done updating data and processing the cubes (normally 6:00 am), it sends an email to all relevant people with a message about new data available within 5 minutes and a link to the folder with the reports.
3. If the job finishes and reports failure an email is sent to me and the IT department.

best regards

Edited by user Friday, December 4, 2015 1:11:05 PM(UTC)  | Reason: Not specified

Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.