Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [scheduled-tasks]

62 questions
68
votes
4 answers

How to run recurring tasks on Postgresql without an external 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. Do you know of an "internal" alternative which…
Stephan
  • 1,513
  • 4
  • 18
  • 27
13
votes
3 answers

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 the job scheduler in pretty much every case,…
SqlRyan
  • 1,206
  • 2
  • 17
  • 24
13
votes
3 answers

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 create SQL Server Agent jobs or modify schema, I…
Ivan Koshelev
  • 245
  • 1
  • 2
  • 6
7
votes
2 answers

When did this SQL request yield results?

I'm working on an SQL server database, containing orders and machines, executing those orders. Not more than one active order can be assigned to a machine at the same time. In other words: this SQL request can never yield a result: SELECT MachineId …
Dominique
  • 609
  • 1
  • 7
  • 23
7
votes
2 answers

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 space by dropping objects in the filegroup, or…
Aruna Raghunam
  • 183
  • 1
  • 2
  • 7
5
votes
4 answers

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.
user28490
  • 51
  • 1
  • 1
  • 2
5
votes
2 answers

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 understand, every event will be replicated just as it…
Edgar Sampere
  • 53
  • 6
5
votes
1 answer

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.0-72-generic #93-Ubuntu SMP PG: Postgres 9.6.3…
Martina Muscariello
  • 171
  • 1
  • 4
4
votes
1 answer

Why the job's next_run_time is wrong?

I got an issue regarding job stats. So I have a job with the following schedule: Occurs every day every 5 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 12/13/2017. in 11:27 AM 2019-10-20 I ran two scripts to get…
Rauf Asadov
  • 1,313
  • 14
  • 36
3
votes
3 answers

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 about dbms_scheduler and using windows task scheduler…
SHS
  • 152
  • 2
  • 5
  • 14
3
votes
2 answers

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?
Ashkan Mobayen Khiabani
  • 133
  • 5
2
votes
1 answer

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 privileges issue or I may have configured our data import…
MEL
  • 81
  • 1
  • 5
2
votes
0 answers

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 so often. But first, my DBA script(s) need to be…
K.T.
  • 21
  • 1
2
votes
2 answers

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.backup_finish_date) AS VARCHAR(100)) + ' ' +…
Vince
  • 29
  • 1
  • 2
2
votes
1 answer

Disabled SQL Server job still being run

SQL Server 15.0.4395.2 We have a SSIS package that we run to interface with another system. It is (or was) run from a SQL Server Agent job, and scheduled to run every hour. For reasons outside the scope of this question, the link to the other system…
Chris Hunt
  • 121
  • 1
1
2 3 4 5