Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with jobs
Search options answers only
not deleted
user 34
A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.
1
vote
Scheduled backup errors
Why are you using a batch file to backup the databases? Why not put the code in a SQL Agent job and have that kick off the backup?
- 27k
3
votes
Accepted
Moving away from CmdExec steps in job without losing logging detail (SQL Server 2008)
Set the output of the T-sql job step to output to a file. It's on the advanced tab of the job step properties.
- 27k
3
votes
Accepted
Creative workaround for granting edit rights to individual jobs for a group?
In the past to solve this I've created a web based app to allow users to change jobs. … Group's can't be used to own jobs as the job runs under the context of the job owner.
There does need to be a better security model for jobs however. …
- 27k
15
votes
Task scheduler for SQL Server Express
It uses the native SQL Agent tables and procedures (which still exist in SQL Express) to store the jobs replacing the SQL Agent itself. The engine is pretty well done for T/SQL and Dos commands. … Also the editor is only about 1/2 done, but the engine to run the jobs is the important part. …
- 27k