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 4 of 4   
 

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,051 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,550 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,490 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,739 reads
   Items 1 to 4 of 4   
 
Tags
job (2)    
automation (1)    
daily (1)    
etl (1)    
frequency (1)    
interval (1)    
job scheduling (1)    
jobs (1)    
monthly (1)    
msdb.dbo.sysschedules (1)    
schedule description (1)    
sql server 2005 (1)    
sql server agent (1)    
sysjobs (1)    
sysjobschedules (1)    
sysschedules (1)    
weekly (1)