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

Content with tag Job Rss

   Items 1 to 9 of 9   
 

Monitoring job history using Reporting Services

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.  Read more...
By Tomaz Kastrun 2013/09/05 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 6,737 reads

Job and Step Run Checker

A script that shows you jobs and steps that have succeded or failed recently. (basically, a T-SQL version of your SSMS Job Activity Monitor)  Read more...
By Orestes Zoupanos 2013/07/05 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,060 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,051 reads

SQL Job Timeline (Graphical)

This script generates a graphical timeline of all SQL jobs with a variable zoom level  Read more...
By Theo Ekelmans 2013/01/29 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 2,294 reads

Show Job Run Snapshot

Show all job history between two dates. This is much easier than trying to navigate the job history log file viewer.  Read more...
By Monte Kottman 2012/10/19 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 1,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

Check SQL Agent Job Status

Useful for when you have something depending on the outcome of a job.  Read more...
By MyDoggieJessie 2012/01/05 | Source: SQLServerCentral.com | Category: agent
Rating: |  Discuss |   Briefcase | 1,842 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 4,811 reads

UP_COMPACTA_COPIA

I have several problems with my corporate network and therefore need to do all my backups locally, and to make matters worse, still use SQL Server 2005.   Read more...
By Lucas Souza 2011/10/17 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 414 reads
   Items 1 to 9 of 9   
 
Tags
automation (2)    
schedule (2)    
sql agent (2)    
agent (1)    
backup (1)    
backup / restore (1)    
check (1)    
compress (1)    
etl (1)    
files (1)    
graphical (1)    
history (1)    
job activity (1)    
job history (1)    
monitoring (1)    
move (1)    
overview (1)    
permissions (1)    
reporting services (ssrs) (1)    
run (1)    
runtime (1)    
scripting (1)    
security (1)    
status (1)    
step (1)    
timeline (1)