A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.

learn more… | top users | synonyms (3)

0
votes
1answer
608 views

How to set a restart on a TSQL Job?

I currently have an important TSQL job that hangs probably once a week. It moves data from one database to another. It is on a schedule running every 5 minutes indefinitely throughout the day. ...
1
vote
1answer
55 views

How can I log the way in which a job was started?

Using SQL Server Agent, I've created a Job that runs some SQL. This SQL does some work on one database, then adds a row to a logging table on a separate database. The Job is run on a couple of ...
1
vote
2answers
4k views

Disabling certain steps in a job

I have a project coming this weekend where all the jobs has to be stopped but only 1 step in a particular job has to be run. for eg: i have a a 2 step job and the second step must run and the first ...
0
votes
0answers
187 views

Oracle force job to fail via raise_application_error

I have a business-flow consisting of several steps implemented as stored procedures in Oracle. I want wrap the whole flow, which is linear (Step1 -> Step2 -> Step3 ->...) into a job that will run ...
1
vote
0answers
201 views

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE ...
7
votes
2answers
2k views

How to schedule jobs in Sql server 2008 for less than 10 sec?

I want to run a job every 3 seconds, however in SQL Server 2008 we cannot define an interval of less than 10 seconds. The job is used to insert/update visitor information, and segmentation ...
4
votes
2answers
654 views

Alert when Job isn't triggered

I have a Sql Job on my server that is triggered nightly from a remote server (once it has completed its backups). I have successfully configured the job to notify me when it fails, but I would like ...
0
votes
1answer
3k views

Exporting scheduled jobs in Oracle

This is probably very simple but i already exported all but the scheduled jobs i created to subsequent schemas. How can I create a sql script of the scheduled jobs I created in Oracle? I know in SQL ...
0
votes
1answer
239 views

Script to Add a Job to a SQL Server DB

I want to add a job to my DB to make a back up weekly but i want to do it from an script, i've serched and with what i found i made this: CREATE SCHEMA job go CREATE PROC BACKUPS @dir varchar(max) AS ...
0
votes
1answer
1k views

Oracle : Is there a way to grant the ability to run a job to a role?

We have several dbms_scheduler jobs in an 11.2 database that we would like users with a certain role to be able to run. As such, we don't want to grant the ability to run directly to the users, as it ...
5
votes
1answer
4k views

Allow non-sysadmin, non-owner of a SQL Server Agent job to execute it

I have a job that runs an SSIS package. Currently the owner is a proxy account. I can run the job manually from a sys-admin account. Our web service logs in using a limited account. It needs to ...
1
vote
1answer
4k views

SSIS Package Validation Error when Executed From Windows Task Scheduler

I have deployed my SSIS package using the project deployment model to the SSIS catalog and experience a strange validation error when I try to execute the package. I believe this is due to a ...
0
votes
0answers
386 views

Trying to run a shell script from dbms_scheduler . Throws error no matter what the script is?

I am trying to run a shell script from a dbms_scheduler but am getting a bunch of errors :- the job defn :- BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_prog', ...
0
votes
1answer
5k views

How to run SQL Job only on primary replica in AlwaysOn Availability Groups? [duplicate]

I have SQL Jobs that need to only on primary replica on AlwaysOn Availability Group. When jobs were originally created ServerA was primary, at later point ServerB became primary so jobs that were on ...
4
votes
2answers
24k views

deleting large volumes of rows from table efficiently in SQL Server [duplicate]

I have a table that has gotten a little out of control. I am not a DBA per se but seem to recall that deleting a huge volume of rows in one shot can cause transaction log issues, hamper overall system ...
1
vote
1answer
146 views

Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?

A database application I'm working with uses Oracle scheduled jobs to perform certain tasks. The DBA insists that hard-coding the schema name in the procedures that organise these jobs improves ...
1
vote
1answer
2k views

SQL Server Agent cannot log on to “MyServer”

I'm struggling to get our SQL Server Agent to run a maintenance plan, which used to work in the past. (This is on SQL Server 2008 R2.) The original problem was that the SQL Server Agent would not ...
0
votes
1answer
856 views

Executing a SQL Job only once a month and after completion of a specific job

Let me better explain. My first job executes every 15 minutes (top of the hour, 12:15, 12:30 and 12:45). It does this for every day of the week. I have a second job that runs at 1:30 AM on the first ...
3
votes
1answer
204 views

Jobs for cycling error logs

Couple of weeks ago I asked this question Error logs various questions and got the answer I needed. Based on the answer and some readings I want to create the following jobs: cycle the error log ...
3
votes
0answers
132 views

SQL server job has not run and also no entry logged in its history [closed]

I have scheduled a SQL job to run daily at 3am in the morning which creates a batch. It has not run today and i am also not able to fathom what's the reason behind its failure. There is no entry in ...
2
votes
1answer
31 views

Running members of a job subset at different intervals

So I'm wanting to batch a number of stored procedures into one job and would like a number of the procedures to run on a schedule different than that of the main job without setting up a new job for ...
8
votes
3answers
10k views

How to changes or update local server connection in Maintenance plan job

Two days back our client changed one of our Dev Server name After Server Renamed, All my maintenance jobs and other jobs are failing because server name mismatch. We are using sql server 2012 ...
6
votes
1answer
6k views

How to clear an Error 15404 after a DB restart (besides rebooting)

Every so often (e.g. ~months) a SQL Server Agent hourly Job will begin reporting an Error 15404 and continue to do so until intervened with. [298] SQLServer Error: 15404, Could not obtain ...
0
votes
1answer
123 views

Oracle DBMS Scheduler - what if database fails?

We are moving some Oracle overnight jobs off a cron server and running them via Oracle DBMS Scheduler instead. It is my understanding that if the database fails overnight then the job email ...
1
vote
2answers
141 views

SQL Server 2000 optimzation job hasn't run for a while

Our SQL Server 2000 used to run a Sunday morning 3am job of optimizing the database. Somehow it was turned off and hasn't run in a year. We have noticed slow access to the database. We turned it ...
8
votes
2answers
3k views

Error running Powershell Script in SQL Server Agent

I have a SQL job that runs via SQL Server Agent (Running SQL Server 2012 Enterprise). The last step of the job is to run an application located on a network share. Unfortunately I don't know the name ...
2
votes
1answer
6k views

Where EVENTS history are logged/recorded in MySql?

I just setup some stored procedures to run in the event scheduler using CREATE EVENT. I'm trying to find where (if somewhere) the history of it running is stored. I looked at the docs but couldn't ...
1
vote
1answer
889 views

Run a program on a remote computer after a SQL job has completed

We have a SQL Agent Job that performs a few tasks every night (schedulled to run using SQL Agent). The database server is SQL 2012 if that makes a difference. We have another process (a .net program) ...
1
vote
1answer
213 views

Dropping a schedule whose name contain '.'

I was attempting to create a schedule called MYSCHEMA.MYSCHED in my Oracle database using SQL Developer 4.0 Early Access, and there appears to be a bug resulting in a schedule named MYSCHEMA. to be ...
2
votes
1answer
539 views

Moving away from CmdExec steps in job without losing logging detail (SQL Server 2008)

My department currently relies heavily on CmdExec steps in SQL Server Jobs, called using a SQL Server Login. For example osql /e /n /S SERVER01 /U USER /P PA$$$ /d DATABASE_01 /i "\\LOCATION\OF\SQL\...
0
votes
1answer
1k views

Creating a job scheduled based on a specific timezone

I have an Oracle database hosted in Europe. I need to create a scheduled job in the database to send email. I need to send email daily at 17:30:00 in India standard time (IST). I know how to send ...
3
votes
2answers
563 views

Targeting MSX with job on Multi-Server Administration

I am using Multi-Server Administration to execute jobs on multiple targets. This works well, but I am not able to enlist the master as a target. I receive the following error when attempting to enlist ...
3
votes
2answers
1k views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
5
votes
1answer
2k views

Schedule Query and Export

Is it possible, to schedule a simple Query to run Daily and export the received data into an excel file?
3
votes
2answers
3k views

DBMS_SCHEDULER event schedule jobs not executed when triggered almost at the same time

I moved this question from stackoverflow to here as it was marked on hold as off-topic. On Oracle 10g2 DB I have set up multiple event triggered DMBS_SCHEDULER jobs and all of them are subscribed for ...
4
votes
1answer
1k views

How to drop all scheduler events in MySQL 5.6?

In MySQL 5.6 is there a way to drop all scheduler events with an administrative command or do I have to go through them one by one with DROP EVENT [IF EXISTS] event_name?
-2
votes
1answer
2k views

How to run steps in one job sequentially [closed]

I have one job on SQL server Job Agent that has 3 steps. I want to the job to run starting with step one. After step one is complete and only when it completes I want step 2 to start running and so ...
5
votes
2answers
4k views

How to run an exe file exists on a different server from SQL Server Job

We have an exe file on a server, say Server1 which should be run from a SQL job exists on a different server, e.g.: Server2. How can it be done? I know if it's a local file, I can use xp_cmdshell in ...
10
votes
1answer
13k views

How to run recurring tasks on a Postgresql database without a cron-like tool?

I would like to call a stored procedure on a regular basis. On Oracle, I would create a job for this. I have found that Postgresql can mimic this well by using an external tool (cron etc) and PgAgent. ...
1
vote
1answer
558 views

MySql one time event never runs?

Please have a look at below events 1) create EVENT Test1 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 20 second ON COMPLETION PRESERVE ENABLE DO ... 2) create EVENT Test2 ON SCHEDULE EVERY 20 ...
0
votes
3answers
3k views

SQL agent job step's connection managers

Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
2
votes
2answers
12k views

Passing parameters to a procedure executed by DBMS_SCHEDULER

I have a scheduler program that runs a stored procedure that requires input parameters. BEGIN DBMS_SCHEDULER.DROP_PROGRAM (program_name => 'MYSCHEMA.EXPORT_SCHEMA_STARTING'); END; /...
4
votes
1answer
119 views

Scheduled stored procedure on all databases in my server

On SQL Server 2012 (not express edition) I'd like to schedule the execution of a stored procedure every hour. On the same server I have lot of databases with the same structure, and I'm constantly ...
3
votes
1answer
859 views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
0
votes
0answers
428 views

DBA_SCHEDULER_Job is not giving any result

I have created one procedure that is supposed to trigger on 5th date of every month.for that i have used dba scheduler job.but its not triggering. select job_name,status from dba_scheduler_jobs; ...
0
votes
2answers
5k views

Running a Job from a Stored Procedure in another server?

How can I run a job from another server using a stored procedure? Let's say server 1 : db1 server 2 : db2 username : testssis password : testssispass sqljob found in db2: job1 Here is the part ...
5
votes
2answers
728 views

Update strings for all cmdexec Jobs

Does anyone know if it's possible, (and furthermore advisable) to update all cmdexec strings in jobs on a server? We'd like to change our logging location, and in principle I'd think this could be ...
0
votes
0answers
283 views

MySQL scheduler is not running

I have created a few events in my db. One is to daily create partition. Another is to summarize data on every second from another table. I notice everything is not running. What would have caused the ...
2
votes
1answer
3k views

Specify Server for DBMS_Scheduler Job in Policy Managed RAC

A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
1
vote
1answer
613 views

Postgresql Run 'Jobs' At Specific Times

I have a normal problem to anyone that can't trust on applications to do their 'work/ AKA be online' and needs a DB Stored Procedure to run every minute . Scenario : PostgreSQL 9.2 Need To Run A ...