Click here to Skip to main content
15,946,179 members

Comments by Member 10754595 (Top 18 by date)

Member 10754595 26-Mar-19 9:13am View    
Hi David,
Thanks for your reply. I have created one task scheduler which was running fine with vb script. and that script i am using to send email reminder. which is connecting with MVC controller. I did not change anything in the code.The MVC is using SQL Database.

Now the problem is I created one test database from production database backup. when I am connecting with my test database the script runs fine it sends email notification but with production database it is not doing anything script is running successfully but not sending any notifications.

here is my script...
Call ScheduleTask()

Sub ScheduleTask()

On Error Resume Next


Dim objRequest
Dim URL

Set objRequest = CreateObject("Microsoft.XMLHTTP")
URL = "http://localhost:59409/ScheduledJobs/CheckIncompleteDocuments"

objRequest.open "GET", URL , false

objRequest.Send

Set objRequest = Nothing

End Sub




Please let me know if you would like to see my MVC code.
thanks
Member 10754595 29-Nov-17 14:06pm View    
Now it did work (DepartmentID ?? 1) with 1 not with 0
Thanks a lot for your help! it saves my day.
Member 10754595 29-Nov-17 13:32pm View    
sorry did not work
got an error below.

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dbo.Documents_dbo.Departments_DepartmentID". The conflict occurred in database "ABC", table "dbo.Departments", column 'ID'.
The statement has been terminated.
Member 10754595 16-Nov-17 14:21pm View    
Deleted
FirstName LastNameEmployee_IDDocument_IDComplete
Patricia Kelly 3 256 1
Patricia Kelly 3 270 1
Cheryl Casto 4 271 0
Dustin Hick 6 353 0
Larry Miller 8 354 0


Member 10754595 16-Nov-17 14:09pm View    
just want to know why the same query is working for complete but not for incomplete.
there is a report which is fetching data from the document and employee table employeeID and document id only will appear in the signature table if someone has sigh off from that document. I don't know how I can show my table structure to you