The tag has no wiki summary.

learn more… | top users | synonyms

-2
votes
0answers
21 views

Schedule daily snapshot task

I want to create a daily snapshot table based on records from product table. I want to run the following query every day at certain time: INSERT INTO ProductSnapshot SELECT NewSnapshotId(), ...
1
vote
0answers
47 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
194 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
8k 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.
2
votes
1answer
3k 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
150 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 ...
1
vote
2answers
1k 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, ...
1
vote
1answer
586 views

Scheduled event did not start when expected

I have created one event schedule which looks like this: mysql> show create event event1 -> ; ...
8
votes
3answers
807 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 ...