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

Articles with tag Jobs Rss

Search for any content tagged jobs

   Items 1 to 20 of 28    Older >>
 

Opportunity for Business Intelligence developer

Red Gate is looking for a Business Intelligence Developer to work with our internal development team on creating business intelligence solutions. You'll be responsible for designing, building, and testing end-to-end BI solutions using the Microsoft BI stack, so we'll expect you to be passionate about understanding data and generating a universe of analytics for your customers – our Red Gaters.  Read more...
By Press Release 2013/09/04 | Source: Red-Gate | Category: jobs
Rating:  Rate this |   Briefcase | 3,353 reads

Parallel Processing Using Jobs

Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.  Read more...
By Peter Sloboda 2013/04/29 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 6,474 reads

New Custom Metric: Long Running Job

SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.  Read more...
By Press Release 2013/04/05 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,106 reads

Email Job Failures Report to DBA using PowerShell

MySQL introduced its own brand of job scheduling, called Events, in version 5.1. However, some Database Administrators (DBAs) feel that it isn't quite ready for prime time. This article presents a hybrid solution that uses MySQL Event Scheduling to manage the batch jobs and Windows PowerShell for the error handling.  Read more...
By Additional Articles 2012/07/03 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,249 reads

Managing Database Data Usage With Custom Space Alerts

A quick how-to on configuring SQL Server Agent alerts to manage file space usage.  Read more...
By Simon Richards 2012/05/30 | Source: SQLServerCentral.com | Category: alerts
Rating: |  Discuss |   Briefcase | 6,695 reads

TSQL function to detect SQL Agent job state

This article has a T-SQL function to detect the SQL Agent job state.  Read more...
By Bret Lowery 2012/02/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,338 reads

SQL Overview V - Monitoring Long Running Jobs

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.  Read more...
By David Bird 2011/07/29 (first published: 2010/03/24) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 16,683 reads

Monitor SQL Server Replication Jobs

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.  Read more...
By Additional Articles 2011/07/11 | Source: SQL Server Performance | Category: replication
Rating: (not yet rated)  Rate this |   Briefcase | 2,738 reads

SQL Server Agent Jobs without an Operator

I work in a fairly large and unwieldy SQL Server shop. Our environment is the wild west. I have DBAs and Developers on my team that create SQL Server Agent Jobs all of the time and there is never an operator setup to email anyone based on a failure condition. I know the right solution here is to "tame the wild west" by locking down the environment and setting up a change management process, but I think that is a topic for another day. Can you give me some idea of how to identify the new recently created SQL Server Agent Jobs and Jobs without an operator setup to email us for a failure condition? I would like to receive emails when either of these conditions occur. Check out the solution to this tip to learn how.   Read more...
By Additional Articles 2011/06/03 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,585 reads

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2011/02/17 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 4,759 reads

Custom sp_start_job to delay next task until SQL Agent Job has completed

The system stored procedure sp_start_job is a very useful T-SQL command that starts a SQL Agent job. The problem with this is that it starts the job and it doesn't wait until the job is finished and sometimes I want to start a job and wait until the job is finished and move on to another job or task that depends on the result of the previous job.  Read more...
By Additional Articles 2010/11/29 | Source: MSSQLTips.com | Category: jobs
Rating: (not yet rated)  Rate this |   Briefcase | 2,791 reads

SQL Server Agent Job Management Scripts

In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.  Read more...
By Additional Articles 2010/11/18 | Source: MSSQLTips.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,773 reads

SSIS Package to Script All SQL Server Jobs to Individual Files

The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.  Read more...
Rating: |  Discuss |   Briefcase | 9,757 reads

SQL Overview V - Monitoring Long Running Jobs

Continuing with his series on monitoring your SQL Servers, David Bird now looks a a way to fin those long running, active jobs.  Read more...
By David Bird 2011/07/29 (first published: 2010/03/24) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 16,683 reads

Job Status Report with Error Detail

Provides Stored Procedures and SSRS Report to show job status with details of errors.  Read more...
By Royce Bacon 2009/12/15 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 8,787 reads

SQL Server Job Trends on Graphs

 A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...  Read more...
By Bill Nicolich 2009/09/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,070 reads

SQL Server Agent Jobs – Displaying Status in an Application

This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page  Read more...
By Adam Aspin 2009/09/16 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 7,845 reads

Checking the Job Status on Multiple Servers

Keeping track of the jobs you have running across all your servers can be a challenge these days with fewer and fewer employees. New author Sivakumar Mahalingam brings us an article that shows one way to accomplish this task.  Read more...
By Sivakumar Mahalingam 2009/09/07 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,703 reads

Auto alert for SQL Agent jobs when they are enabled or disabled

It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.  Read more...
By Additional Articles 2009/08/13 | Source: MSSQLTips.com | Category: sql agent
Rating:  Rate this |   Briefcase | 3,271 reads

Advice for the Unemployed

Everyone has an opinion on the best advice to give an IT person who is unemployed and wants to get back into paid work. Phil Factor outlines what he would advise.  Read more...
By Phil Factor 2009/07/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 200 reads
   Items 1 to 20 of 28    Older >>