<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
SQL Agent
Items 1 to 20 of 47
Next 20 >>
Stairway to SQL Server Agent
SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.
Read more...
Monitoring SQL Server Agent job run times
Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super...
Read more...
By
Stefaans
2013/05/01
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,233 reads
Providing SQL Agent Job Log Data for Developers
As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.
Read more...
By
Additional Articles
2013/01/29
|
Source:
MSSQLTips.com
|
Category:
sql agent
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,114 reads
Check SQL Job timings
This script is useful to check how long jobs have been running.
Read more...
By
Shishir Tewari
2012/09/11
|
Source:
SQLServerCentral.com
|
Category:
sql agent
Rating:
|
Discuss
|
Briefcase
|
1,479 reads
Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent
It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.
Read more...
By
Dewey Wu
2013/05/22
|
Source:
SQLServerCentral.com
|
Category:
backup
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
37 reads
Working with SQL Agent Durations
SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.
Read more...
By
Kyle Neier
2012/08/23
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
2,735 reads
Startup Jobs
Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...
Read more...
By
2012/08/08
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,231 reads
SQL Server Agent Proxies
Read more...
By
Steve Jones
2012/05/15
|
Category:
sql agent
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,197 reads
SQL Server Agent Roles
Read more...
By
Steve Jones
2012/03/22
|
Category:
security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,293 reads
SQL Server Agent Roles
Read more...
By
Steve Jones
2012/02/28
|
Category:
sql agent
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,126 reads
SQL Agent Roles
Read more...
By
Steve Jones
2012/02/07
|
Category:
security
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,141 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,178 reads
SQL Agent Jobs Summary
The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.
Read more...
By
Smitha Reddy
2011/12/29
|
Source:
SQLServerCentral.com
|
Category:
sql agent
Rating:
|
Discuss
|
Briefcase
|
1,651 reads
SQL Server Agent job information
Read more...
By
Iulian -207023
2011/07/27
|
Category:
jobs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,227 reads
Get an email notification of the failed job step detail
This trigger will notify the existing email operator of the job with detailed job step information.
Read more...
By
Gokhan Varol
2011/02/17
|
Source:
SQLServerCentral.com
|
Category:
sql agent
Rating:
|
Discuss
|
Briefcase
|
2,622 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
|
3,888 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,574 reads
retrieve SSRS report schedule info through SQL
Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.
Read more...
By
Ibrahim Naji
2010/08/20
|
Source:
SQLServerCentral.com
|
Category:
reporting services (ssrs)
Rating:
|
Discuss
|
Briefcase
|
1,487 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...
By
Thomas Lane
2010/07/06
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
9,156 reads
Job History with Timeline
Similar to many other Job History scripts, but unique in that it has a timeline.
Read more...
By
webtekkie
2010/06/01
|
Source:
SQLServerCentral.com
|
Category:
jobs
Rating:
|
Discuss
|
Briefcase
|
2,546 reads
Items 1 to 20 of 47
Next 20 >>
Tags
jobs
(23)
security
(7)
sql server 2005
(4)
administration
(3)
blogs
(3)
monitoring
(3)
powershell
(3)
integration services (ssis)
(2)
job schedule
(2)
permissions
(2)
scheduling
(2)
sql server 2008
(2)
stairway series
(2)
video
(2)
alerts
(1)
backup
(1)
database mail
(1)
generate jobs scipts
(1)
history
(1)
management
(1)
operations manager
(1)
operators
(1)
oracle
(1)
proxy account
(1)
proxy accounts
(1)
reporting services (ssrs)
(1)
restore
(1)
smo
(1)
sql server 2000
(1)
sql server 7
(1)
sql server express
(1)
timeline
(1)
t-sql
(1)
xpath
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
