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

Data Mining: Part 16 Automating Data Mining Processes

In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.  Read more...
By Daniel Calbimonte 2014/09/08 | Source: SQLServerCentral.com | Category: microsoft
Rating: (not yet rated) |  Discuss |   Briefcase | 2,001 reads

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,521 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,981 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,106 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,079 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,410 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,060 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,573 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,873 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,856 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 | 418 reads
   Items 1 to 11 of 11   
 
Tags
automation (3)    
sql agent (3)    
agent (2)    
schedule (2)    
backup (1)    
backup / restore (1)    
check (1)    
compress (1)    
data (1)    
data mining (1)    
etl (1)    
files (1)    
graphical (1)    
history (1)    
job activity (1)    
job history (1)    
microsoft (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)