DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: About Job Scheduling

  1. 01-01-2006, 07:36 AM #1
    vinnuk3
    vinnuk3 is offline Junior Member
    Join Date
    Jan 2006
    Posts
    2

    About Job Scheduling

    Hi All,
    I have one problem in Production. I have one procedure. In That procedure have one cursor which takes data from 3 to 4 tables and it will create one .txt file in the Server and data writes into that file.
    When I run from this procedure through Application it is taking 1 hr 15 min with in that time application time out is happening but When I run through Backend it is taking only 10 to 15 seconds.
    But it's not possible to run from the backend every day. Is there any alternate solution for this problem.
    Please Suggest me.

    Note: This Procedure I need to run Before Date Change in Application. So I need to Run this Process Before Run the Date Change Process in Application. to run the Date change in Application there is no Fixed time. Date change process will be run through application.

    Thanks in advance...

    Thanks & Regards
    Vinod Kumar K
    Last edited by vinnuk3; 01-01-2006 at 07:46 AM.
    Reply With Quote Reply With Quote
  2. 01-01-2006, 09:08 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    trace the query - see what itis doing
    Reply With Quote Reply With Quote
  3. 01-02-2006, 03:41 AM #3
    vishaldesai_28
    vishaldesai_28 is offline Junior Member
    Join Date
    Jan 2006
    Posts
    2
    Probably you can write a shell script to run this procedure from the same server.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width