VBScript

Vbsript to execute a Oracle PL/SQL Procedure

Rem Name of the PROCEDURE Dim strProc : strProc =”POPULATE_EMP_DATA” Rem Name of the DB SCHEMA Dim strSchema : strSchema = “bhive_report” ‘########## TARGET DB DSN Dim TargetDSN : TargetDSN = “devDSN” Dim TargetDBuser : TargetDBuser = “devUSER” Dim TargetDBpwd : TargetDBpwd = “devPASS” Call runPROC(TargetDSN,TargetDBuser,TargetDBpwd,strProc,strSchema) Rem Sub Routine to Execute Stored Procedure Rem Generic… Continue reading Vbsript to execute a Oracle PL/SQL Procedure

VBScript

Delete Temp Folders using Vbscript

‘######################################################## ‘# Title: Script to Delete Temp Folders in Computer # ‘# Date: 18 December, 2012 # ‘# Author: Saqib Mujtaba,WT # ‘######################################################## Option Explicit On Error resume Next Dim objFSO,strWinFolder,WshShell,i,objLogFile Set objFSO = CreateObject(“Scripting.FileSystemObject”) Set objLogFile = objFso.OpenTextFile(“Delete.Log”,2 ,True) objLogFile.WriteLine now & “[================ LOGGING STARTED ================]” Set WshShell = CreateObject(“WScript.Shell”) Set strWinFolder = objFSO.GetSpecialFolder(0)… Continue reading Delete Temp Folders using Vbscript