Question : Can you please help me how to execute a stored procedure automatically in SQL database without any transaction […]
Tag: scheduled-tasks
Schedule database backup question
Question : Good day. This may be a stupid question and you can give me a stupid answer if you […]
How to stop the SQL Server Agent Job Scheduler with T-SQL?
Question : I have a job that I manually start in coordinated time periods that does a bunch of heavy […]
Scheduling queries to run when sql server is not busy
Question : Is it possible to schedule some queries not for specific times but to run when sql server is […]
Scheduled event did not start when expected
Question : I have created one event schedule which looks like this: mysql> show create event event1 -> ; +——–+———-+———–+——————————————————————————————–+ […]
How to send alert on SQL Shutdown due to Audit Failure
Question : Looking for a way to implement this STIG. What method should I use to monitor SQL Server, when […]
Is there any way to Rebuild (and Reorganize) the indexes automatically?
Question : I have created some non-clustered index on my tables in SQL Server 2014. Is there any way to […]
Create a job from dbms_scheduler with stream redirection?
Question : I want to create a simple job who have to execute this shell command: echo some_text > some_file […]
I’m using the SQL Server Agent to schedule even non-database tasks – is this a bad idea?
Question : Since I’m a DBA (and in many cases, the de-facto sysadmin), SQL Server is installed on pretty much […]
executing a stored procedure on a monthly schedule
Question : I’m looking to create an invoicing procedure that executes automatically once a month. The procedure name is INVOICE_PROC. […]