Question : How I can configure AutoMySQLBackup to backup some selected tables ones per week while the other tables will […]
Tag: automation
Alternate of trigger in SQL server
Question : is there any other way beside creating a trigger in MSDB system tables to invoke a particular job […]
PostgreSQL – automating database grants [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
View the role assigned to each user (Report Server)
Question : Is there anyway I could list down the roles assigned to each user on the different folders on […]
Mongodb automatic Replica Set creation with JS driver
Question : The MongoDB docs state that one can use the mongo client console to initialize replica sets by running […]
is there any reason to explicitly grant the server permission CONNECT SQL?
Question : I have been using this script from Kenneth Fisher to get the server permissions. — Server Permissions SELECT […]
How can I inform myself that an automatic SQL Server process has worked?
Question : I have a Windows batch file which extracts some data from a remote system and then imports it […]
Auto running SQL script
Question : I am using the below command in my batch file and running it via task scheduler. osql -S […]
How to automate the changes of parameters in ssis package run by a job?
Question : I have a job that runs a package with specific parameters as you can see on the picture […]
Postgresql Backup all databases seperate files
Question : I need to create an automatic backup of all databases from PostgreSQL ( running on a Windows machine […]