Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

The tag has no usage guidance.

2
votes
1answer
29 views

Schedule database backup question

Good day. This may be a stupid question and you can give me a stupid answer if you need to. I know you can schedule a task to backup a sql database at logon, shutdown, specific time, etc. But What I ...
0
votes
2answers
55 views

How to stop the SQL Server Scheduler with T-SQL?

I have a job that I manually start in coordinated time periods that does a bunch of heavy lifting (mostly restoring backups and configuring for a different server) There are several jobs scheduled to ...
2
votes
2answers
44 views

How to find a SQL Job details in Production environment?

There is a stored procedure being executed daily which inserts a record in a specific table. Our Production database servers has lot of SQL jobs scheduled to run daily at different intervals. How to ...
0
votes
1answer
17 views

Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows

I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. ...
0
votes
0answers
36 views

Alternative to Celery to integrate multiprocessing management

I have a queue where data are loaded, it takes about 1 minute to process over each data in queue, and I want to process them in parallel. is there any alternative for celery to handle this scenario? ...
0
votes
0answers
58 views

Not able to run mongorestore job from schedular task on windows

I have a Shell Script under which restore command is mentioned for restoring the DB from target folder. My File name will be mongorestore.sh NOTE: Dump data location will be E:Backup/test #!/bin/...
1
vote
1answer
119 views

Create a job from dbms_scheduler with stream redirection?

I want to create a simple job who have to execute this shell command: echo some_text > some_file The attributes some_text and some_file can change between two calls to run_job so I need to use ...
4
votes
1answer
729 views

Pg_cron crontab log issue

We're trying to configure periodic jobs in PostgreSQL. To do this, we have installed on Linux machine, with Postgres 9.6 running, the citusdata pg_cron project. System information: OS: Linux pg 4.4....
10
votes
3answers
7k views

Automatically execute query in MS SQL Studio every hour

I support an application in a big enterprise, one of my roles is to clean-up data. There is a query I need to execute every hour, and I would like to automate it. Due to organization policies, I can't ...
1
vote
1answer
38 views

Serializability schedules: can someone help me understand it?

I am struggling with the Databases courses I have, so I am trying to find answer to my question. This has been asked: Add the appropriate locks to enforce serializability on the following ...
2
votes
3answers
3k views

Ways to Schedule Rman backups

I am using oracle 11g database in windows platform. Also, my db is in archivelog mode and I am taking daily RMAN backups. Now, I need to schedule my Rman backups on daily and weekly basis. I read ...
4
votes
2answers
288 views

Scheduling queries to run when sql server is not busy

Is it possible to schedule some queries not for specific times but to run when sql server is not busy? Is there any way to calculate the business of the sql server?
0
votes
1answer
27 views

How to create a CSV file which imports data from an Access Database on a Weekly Schedule?

I have very little experience in database management but have come across a problem I am unable to find a solution to online. I currently have access to a database which is updated in real time with ...
2
votes
2answers
48 views

Generating Backups of Databases

I would like to create a backup of four databases on one SQL Server 2000 instance at the exact same moment in time. How can I achieve it? Creating different jobs with the same schedule date and ...
1
vote
1answer
517 views

what does that mean? COMMAND [PeriodicTaskRunner] task: UnusedLockCleaner took: 273ms

With mloginfo I found a strange log entry. Didn't find anything about it in MongoDB docs and other related sites. $ mloginfo mongodb.log --distinct source: mongodb.log host: example ...
1
vote
2answers
685 views

Is there any way to Rebuild (and Reorganize) the indexes automatically?

I have created some non-clustered index on my tables in SQL Server 2014. Is there any way to Rebuild (and Reorganize) the indexes automatically? I mean is it possible to schedule them to be built ...
0
votes
1answer
268 views

Always On: SQL Agent can still run stored proc on inactive server

We have the AO Clustering - HA&DR Hybrid configuration. Out of a dozen databases only this one database/application is encountering this. The problem is that we have a SQL Agent Job scheduled to ...
0
votes
1answer
411 views

how to find out the next time a job is scheduled to run in sql - in real time and even if the job has never been run before

I have a very similar question here but the problem with that question/ answer is that it does not work for all situations. for example, for the jobs that I have just created and have not been run as ...
0
votes
0answers
289 views

Is it possible to configure exceptions for SQL Server Agent tasks?

I use SQL Agents tasks to execute my backup, maintenance & ETL tasks. IT would like to have a regular maintenance window to apply server patches. They're suggesting the 3rd Tuesday of every month ...
0
votes
0answers
24 views

SQL Server Job does not execute when scheduled, but does execute manually, how do I get it to run as scheduled? [duplicate]

I am running SQL Server 2014 SP 1 CU 5. The job did work in the past. The schedule is enabled. The account it is running under is an ADS account which has sysadmin rights and has delete rights to the ...
2
votes
0answers
541 views

Automatic task scheduler is not working [closed]

I created a DB2 task to run my stored procedure automatically at a specific time, so below are the steps which I followed: First of all I enabled the task schedular using this command: db2set ...
1
vote
1answer
629 views

pg_dump fails to create a backup when running from System User in Windows Task Scheduler

I am trying to run a pg_dump through a scheduled task in windows. I have two batch files. One creates the task. The other one runs the pg_dump. Even though the pg_dump works with the current user with ...
2
votes
1answer
2k views

Automate backup using Windows Task Scheduler

I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler. I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
2
votes
2answers
9k views

Insufficient disk space in Filegroup

One of my jobs is failing and it shows below message. Error: Could not allocate a new page for database 'Reporting' because of insufficient disk space in Filegroup ‘PRIMARY’. Create the necessary ...
1
vote
0answers
78 views

Bypass stored procedure execution CPU consumption

We are using Microsoft SQL Server Agent Jobs to execute stored procedures on the other database systems (like MySQL or Oracle). Usually we run procedures via linked servers (over OLEDB and ODBC ...
3
votes
0answers
21k views

Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist/Tasks [closed]

Recently I'v achieved Oracle Database 11g Administrator Certified Associate (OCA) after passing two exams (1Z0-051 & 1Z0-052), then I got a Job as an Oracle DBA in startup company. So, I would ...
1
vote
1answer
265 views

Most efficient table storage for determining recurrence

What is the most optimal table structure to store schedules / recurrence definitions so that we can efficiently query it for all events that will occur within a date range (min:1 max:32 days)? My ...
1
vote
1answer
59 views

Backup a MySQL database -options

I'm relatively new to database driven sites. In order to backup a database I use phpMyAdmin's Export function from the server and download the output to my computer. That works, but it requires me to ...
0
votes
0answers
667 views

pgAgent does not run

I referred this to set up a scheduled job and did everything as it mentioned(ran the pgagent.sql as well) I need a very simple task to run periodically. In the 'Definition' tab in the steps, few ...
2
votes
1answer
6k 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 ...
2
votes
0answers
170 views

Scheduling a task to run after a SQL SERVER 2012 executes a different set of scripts?

Im working on a project for a job I am interning for. I've had a few months of database design. I am still learning all the techniques. I am currently trying to schedule a console app to run every ...
1
vote
3answers
580 views

Aggregating data - Getting data inserted after last time query was run

On a SQL Server 2008 R2 DB, I'm running an aggregation query every hour or so, on data that's being constantly inserted into a table, and what I'd like to do is pull all the "new" records that were ...
3
votes
3answers
41k views

How to automatically execute a stored procedure every day at a particular time?

Can you please help me how to execute a stored procedure automatically in SQL database without any transaction in SQL? I want to execute on particular fix time.
36
votes
2answers
39k 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. ...
5
votes
1answer
662 views

How to schedule PostgreSQL replication?

I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen. I'll be using postgres internal replication solution but as far as I ...
2
votes
2answers
7k views

Running a query within a scheduled job

I am looking at running the following query within a scheduled job weekly: Select TOP 10 s.database_name, m.physical_device_name, CAST(DATEDIFF(second, s.backup_start_date,s....
1
vote
1answer
6k views

Scheduled event did not start when expected

I have created one event schedule which looks like this: mysql> show create event event1 -> ; +--------+----------+-----------+---------------------------------------------------------------...
12
votes
3answers
3k views

I'm using the SQL Server Agent to schedule even non-database tasks - is this a bad idea?

Since I'm a DBA (and in many cases, the de-facto sysadmin), SQL Server is installed on pretty much every server I have to work with regularly. I realized recently that I've been using the SQL Agent as ...