Question : I have created some non-clustered index on my tables in SQL Server 2014. Is there any way to […]
Tag: scheduled-tasks
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. […]
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 […]
Running a query within a scheduled job
Question : I am looking at running the following query within a scheduled job weekly: Select TOP 10 s.database_name, m.physical_device_name, […]
Backup a MySQL database -options
Question : I’m relatively new to database driven sites. In order to backup a database I use phpMyAdmin’s Export function […]
Run a stored procedure only the last 3 days in a month
Question : How can I run a stored procedure only the last 3 days of a month using a T-SQL […]
Generating Backups of Databases
Question : I would like to create a backup of four databases on one SQL Server 2000 instance at the […]
SSIS connection used based on passed value
Question : I have an SSIS package that populates a reporting warehouse from a live and test environment. Currently the […]