Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag schedule Rss

   Items 1 to 5 of 5   
 

Report overlapping jobs

This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.  Read more...
By Wilfred van Dijk 2014/07/31 | Source: SQLServerCentral.com | Category: sqlagent
Rating: |  Discuss |   Briefcase | 1,253 reads

Find the Currently Running Scheduled Job

Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.  Read more...
By Stefan Krzywicki 2013/04/25 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 5,098 reads

Self Scheduling Jobs

Jobs with a calcuable run date can self schedule themselves.  Read more...
By Richard Noordam 2012/06/20 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 8,582 reads

get schedule description

workaround the bug in msdb..sp_get_schedule_description  Read more...
By Matthias Kroll 2010/04/08 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,510 reads

SQL Server Agent Schedule Decoder

This script will break job schedules down into a readable format (msdb.dbo.sysschedules)  Read more...
By Michael Abair 2010/01/06 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,804 reads
   Items 1 to 5 of 5   
 
Tags
job (2)    
jobs (2)    
automation (1)    
daily (1)    
etl (1)    
frequency (1)    
interval (1)    
job scheduling (1)    
monthly (1)    
msdb.dbo.sysschedules (1)    
performance (1)    
schedule description (1)    
sql server 2005 (1)    
sql server agent (1)    
sqlagent (1)    
sysjobs (1)    
sysjobschedules (1)    
sysschedules (1)    
tuning (1)    
weekly (1)