Re: sql agent/job executing question

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/08/04

  • Next message: Allan Mitchell: "Re: Call function to fill column in DTS tranformation" 
    Date: Tue, 8 Jun 2004 20:33:26 +0100

    You guess correctly. If the job is still executing when the previous
    invocation is still running then the schedule is missed until the next time 

    -- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Alexander Nenashev" <nenashev@hotbox.ru> wrote in message
news:%23c4Gd$VTEHA.3988@tk2msftngp13.phx.gbl...
> i guess when sql agent is executing a job and
> time has come to run it again while the job is still running,
> sql agent just doesn't run it but waits untill the job is complete.
> do i guess right.
> is there info in bol?
>
>
  • Next message: Allan Mitchell: "Re: Call function to fill column in DTS tranformation"

    Relevant Pages

    • Re: Limitations of Scheduled jobs
      ... > Actually we can schedule the jobs with accuracy less than ... where executing the stored procedure ... >>on what the stored procedure does exactly. ... >>SQL Server MVP ...
      (microsoft.public.sqlserver.programming)
    • Stored procedure does not complete until result set is retrieved from ODBC
      ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
      (microsoft.public.sqlserver.odbc)
    • Re: Access while running DTS package using stored procedure
      ... The permissions when executing xp_cmdshell can be different depending on who ... which the SQL Server service is running. ... > I wrote a DTS Package that can take the data from a .txt file residing ... > Declare @RunDTS as varchar ...
      (microsoft.public.sqlserver.dts)
    • Re: Database Growth & Space Recovery Problem
      ... but the sysindexes info is ... Wayne Snyder, MCDBA, SQL Server MVP ... > build havinf nvText Field with large no of records. ... After Executing the Shrink Database from Enterprise Manager. ...
      (microsoft.public.sqlserver.datawarehouse)
    • DTS ERROR 8004206A
      ... There're 11 subpackages in a main package.Every subpackage will first delete ... (by executing a store procedure) ... then transform data from INFORMIX to SQL SERVER. ... Microsoft Data Transformation Services Data Pump ...
      (microsoft.public.sqlserver.dts)