Job Schedule

I have fe reports that are scheduled to kick of every month on certain day. It used to work perfectly fine as I used to get notifications as soon as th report ran.

But from past three months I didn’t get any notification as emails.When I check the job manager it displays the status as success.

It’s really weird and I am not sure what’s going wrong ?

Did anyone experience this ?

Go to the Windows Task Scheduler. Find you job and look at the Last Run Time, Last Run Result, and Next Run result. This window might have more details.

Has your email server changed recently? Check to see if you can send an email from an automation job with a test run (not scheduled). You may need to reconfifure the email send properties. If nothing has changed in Toad (no upgrades or anything) then it is probably your environment that has changed.

@Debbie Peabody Thank you. I did what you instructed but everything looks good.

[mention:d79756b87c62429d89ea1759b6119b92:e9ed411860ed4f2ba0265705b8793d05] Thank you. I will check if I find any luck

Can you post screenshot? Just in case I can see anything suspicious?

@Debbie Peabody [mention:d79756b87c62429d89ea1759b6119b92:e9ed411860ed4f2ba0265705b8793d05] It runs perfectly fine when I run it manually. I will attach a screenshot soon.

Check with your network security people. They may have changed some permissions that do not allow a scheduled process to access the mail server or even not allow the scheduled job to do anything. Can you tell if the job did what it was supposed to do (like create a file or put data in some table)?

[mention:d79756b87c62429d89ea1759b6119b92:e9ed411860ed4f2ba0265705b8793d05] : I am pulling data from some tables and sending the result report to my client through an email.

Does the result report get created (can you find the Excel or csv file that gets created prior to getting attached to the email)? Does the client get the email?

If you want to open a support case we can set up a WebEx and see what might be going on in your environment.

[mention:d79756b87c62429d89ea1759b6119b92:e9ed411860ed4f2ba0265705b8793d05] : I did following test cases in order to debug it more .Basically these reports are on server machine where I login remotely to schedule the reports.

  1. Scheduled the report and everything works fine if stayed online on the server.

2)The schedule fails if I log off from the server.When I login back to check the schedule status then the status says “success” but no report is generated through email or either in the file report location.

The thing is reports scheduled more than a year works perfectly fine but reports that are scheduled recently like 6 months are not working.

Do you have any suggestions in this regard ?

[mention:c51459804ebd46679755185a35a001ea:e9ed411860ed4f2ba0265705b8793d05] I think I will open a ticket with support center.

When I ran Toad automated jobs on a server you had to make sure the job can log in. The way they had security set up you had to stay logged in or the job would not start. Eventually I got them to set up a service account to run the Toad jobs to get around this problem. Talk to your network security and who maintains the server that you are running Toad on. Did you upgrade Toad on the server six months ago? It is possible that the old jobs are still running on a previous version and you have a problem with the new version (in which case both versions are still on the server with the new jobs in the last 6 months running the new version and the old jobs are still calling the exe from the old install, you can check this by looking at the job in windows scheduler).

[mention:d79756b87c62429d89ea1759b6119b92:e9ed411860ed4f2ba0265705b8793d05] I am using toad 3.2 all the time and I have not upgraded my Toad from long time but I will check with my security .If nothing works then I will follow what [mention:c51459804ebd46679755185a35a001ea:e9ed411860ed4f2ba0265705b8793d05] suggested. Thank you guys for your available suggestions.