?
Solved

debug live scheduled job

Posted on 2008-11-13
1
Medium Priority
?
324 Views
Last Modified: 2012-06-27
Hello Experts,

Since last few weeks most of the scheduled jobs are not working on the live webserver.
These are basically a VB project.EXEs which gets triggered every wednesday night to import and export data.

I think something went wrong when I tried to move the complete website from the Dev to the Live environment and I think the database reference has been changed or something else.

I wanted to debug them to find out where and what is the error.

On the live I do not see the actual code of these EXEs, I can certainly find them on the DEV server. What I dont understand is whether one have generated EXE on the server or it could have been copied from the Dev to the LIVE server ? If they have been copied then database details on the dev is different than
to the one on the server.

Its keep happening every other week making things more complicated.

Please can someone guide me through here?

Regards
Kay
0
Comment
Question by:learningnet
1 Comment
 
LVL 7

Accepted Solution

by:
moseack earned 2000 total points
ID: 22950712
If you're using visual studio 2005 or 2008 you can use Remote Debugging (Debugging the Live machine from the Dev machine):
http://msdn.microsoft.com/en-us/library/bt727f1t.aspx
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question