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

Create notifications for failed jobs with one easy script

Here an easy way to setup alerts for all sql agent jobs. Typically I use this to send an email alert when a job fails. I always setup a group email address rather than individuals to make this a one-time setup.  Read more...
By Patrick Akhamie 2014/05/12 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,419 reads

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,912 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,093 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,062 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,384 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,056 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,562 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,862 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,843 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 | 416 reads
   Items 1 to 10 of 10   
 
Tags
sql agent (3)    
automation (2)    
schedule (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)    
notification (1)    
overview (1)    
permissions (1)    
reporting services (ssrs) (1)    
run (1)    
runtime (1)    
scripting (1)    
security (1)    
status (1)    
step (1)    
timeline (1)