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: | Category: microsoft
Rating: |  Discuss |   Briefcase | 2,668 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: | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,697 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: | Category: job
Rating: |  Discuss |   Briefcase | 7,323 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: | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,151 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 Sioban Krzywicki 2013/04/25 | Source: | Category: automation
Rating: |  Discuss |   Briefcase | 5,122 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: | Category: job
Rating: |  Discuss |   Briefcase | 2,961 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: | Category: job
Rating: |  Discuss |   Briefcase | 1,077 reads

Self Scheduling Jobs

Jobs with a calcuable run date can self schedule themselves.  Read more...
By Richard Noordam 2012/06/20 | Source: | Category: job
Rating: |  Discuss |   Briefcase | 8,611 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: | Category: agent
Rating: |  Discuss |   Briefcase | 1,942 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: | Category: automation
Rating: |  Discuss |   Briefcase | 4,894 reads


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: | Category: job
Rating: |  Discuss |   Briefcase | 422 reads
   Items 1 to 11 of 11   
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)