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
Content with tag
Job
Items 1 to 7 of 7
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
|
4,631 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
|
1,797 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
|
983 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,463 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,706 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,701 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
|
407 reads
Items 1 to 7 of 7
Tags
automation
(2)
schedule
(2)
agent
(1)
backup
(1)
backup / restore
(1)
compress
(1)
etl
(1)
files
(1)
graphical
(1)
history
(1)
move
(1)
overview
(1)
permissions
(1)
runtime
(1)
scripting
(1)
security
(1)
status
(1)
timeline
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.