i have sql server job. in the last step of job i want to stop/start sql server.
I create .bat file with
NET STOP "MsSqlServer"
i try ssis package that use execute process task with cmd.exe and execute .bat file to stop start
mssqlserver and it work fine...
but when i call this packge in the sql server job .it stop the service but not start the services
the question is how to stop/start sql server after another sql serve job complete..?
i have sql server/analysis services/reporting services in one station with 64 GB Memory.and i have nightly job with this steps :
1-ETL that Update DW
2- Process Analysis services Database 3-Update Reporting services Subsciptions sometime in beginning the AS Processsing in the step 2 it give me errore: there is no resource Available and and the job got failed.all i want is good memory configuration for this environment. what startegy i must choose for Memory Management. another problem is after step 2 for update subscription(i have about 50 Subscription) if i try Update Subscription with clean memory (i mean if i restart sql server service )the subscription execute very fast.and if i dont restart the sql services it take long time to run and sometime it never give me results.