User Profile

Collapse

Profile Sidebar

Collapse
BerndSX
BerndSX
Last Activity: Oct 26 '11, 12:13 PM
Joined: Oct 25 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BerndSX
    replied to Agent Job Duration exceeds manually launched program duration
    in SQL Server
    Thanks a lot for your reply !! :)

    This is indeed true, but the job is run under the sa admin account ! So I wouldn't expect a problem in this direction.

    I am watching a dependence on regarding the number of records in the inner cursor cc3.
    The hangup occurs when then number of records starts exceeding 8.000 to 10.000 rows
    See more | Go to post
    Last edited by NeoPa; Oct 26 '11, 01:05 PM. Reason: Removed unnecessary quote

      Leave a comment:

    • BerndSX
      started a topic Agent Job Duration exceeds manually launched program duration
      in SQL Server

      Agent Job Duration exceeds manually launched program duration

      Hi folks,
      I am really despaired.
      I have a SQL Programm (sql server 2005), nothing wild, which consists mostly on a static cursor which runs over about 100000 Records and executes a stored procedure copying these records to other tables.

      When run manually in the Management Studio , the job is done in about 20 to 30 minutes. If it runs inside a sql server agent job it goes banana with over 20 hours.

      What...
      See more | Go to post
      No activity results to display
      Show More
      Working...