Skip to main content
54 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-1 votes
0 answers
39 views

I've built an RPA that runs fine as a .py. I turned it into an .exe and it ran fine that way as well. Next I moved it to the production server that it will run from and using File Explorer, double ...
JimmyG's user avatar
  • 655
0 votes
0 answers
104 views

I want to set SQL Server log shipping for all databases on a server. When I configure database (on master side) one by one, there is no problem. Problem occurs when put configuration ( for master side ...
LDonSOvrfw's user avatar
  • 49
0 votes
0 answers
107 views

I get a zip file that includes a database backup from our customer that needs to be restored on our server on a regular basis. The restore is done on an staging server, the data is than processed ...
scarabeaus's user avatar
  • 15
0 votes
0 answers
52 views

I have an SSIS package that generates a CSV output file with a dynamically generated name based on the current date and time. The expression for the file name is set in the FilePath variable within ...
Nico M.'s user avatar
  • 17
0 votes
0 answers
68 views

I have an update statement I need to run on a table, however due to the size of this table the update takes an incredibly long time to run. I want to create a SQL server job to run this update script ...
Sherwin Moodley's user avatar
  • 1
0 votes
1 answer
536 views

I am trying to run an XMLA command that kicks off an Xevent trace as a SQL Agent Job. (below) The command works fine in SSMS as an XMLA query. When I try to save this step as an SSAS Command in an ...
Bill Park's user avatar
  • 3
0 votes
1 answer
689 views

Maybe somebody can provide assistance for the following question: I have a SSIS package with Target SQL Server Version 2014. I am not 100% sure which version my target server is running, but it is at ...
Monty Burns's user avatar
  • 101
0 votes
0 answers
56 views

In our project, we have a lot of SQL Server Jobs (Local SSIS package) and in all of them, we have some common properties. We don't find a way to "place" these properties somewhere to be used ...
ElRoro's user avatar
  • 223
1 vote
1 answer
4k views

I have two SQL Server machines: SqlServer-1 SqlServer-2 I have a job created on SqlServer-1 named RunExeFile. SqlServer-2 can access SqlServer-1 through a linked server. Can I start the job ...
Ali's user avatar
  • 99
0 votes
1 answer
977 views

I need to understand what a certain job in SQL Server 2012 does. It's a job someone created and left the company before I started to work here, and nobody on my team knows what this job does also. The ...
Emily's user avatar
  • 11
1 vote
1 answer
3k views

I have ETL packages that works fine in Visual Studio 2019 When we deploy and run it from SQL Server Agent, it gives the error below Additional info: the package is set to "Encrypt sensitive with ...
Mohamed ElSheikh's user avatar
  • 176
0 votes
0 answers
899 views

I have a SQL Server Job which has some steps include execution of store procedures. The job ran successfully. However, some steps which executes store procedure did not run fully as per my ...
Jay Desai's user avatar
  • 871
0 votes
0 answers
950 views

I have a SSIS package that I want to run in SQL Server Agent T-SQL job using Stored Procedure since I have a permission issue described in my other post: Using Proxy to give SQL Server Agent windows ...
Shannon Lin's user avatar
  • 1
1 vote
1 answer
524 views

I have this step in sql server job AAA.bat content is this call BBB.bat call CCC.bat BBB.bat and CCC.bat each run ETL packages. When I run above step it throws error BBB.bat is not recognized as an ...
Eric Klaus's user avatar
  • 953
1 vote
0 answers
432 views

I have a SQL Server(2014) Job scheduled run at "AM 11:00" on everyday. I saw the job's log at "2020/01/08 AM 11:40", the Windows server's clock tool displayed right. But I find out the job's last ...
Mortiz.H's user avatar
  • 11
0 votes
1 answer
813 views

Summary: I've setup a python script (simplified in this case, removing all ODBC/SQL statements) that creates two log files in a child directory. I then created a exe file off of this named TestApp....
Andrew Lindner's user avatar
  • 15
0 votes
0 answers
562 views

While exploring the SQL server I came up with following system tables: sys.dm_exec_background_job_queue; sys.dm_exec_background_job_queue_stats; Official site tells that It Returns a row for each ...
Santosh Kale's user avatar
  • 111
0 votes
1 answer
2k views

I have a SSIS package with a Execute Process Task that runs an exe. All code and executables are located on the same server. The SSIS package runs inside the project but not when I upload to SSIS ...
the mad cat's user avatar
  • 3
3 votes
1 answer
2k views

I have a Sensitive String Parameter on an SSIS Package that is used to store a password for a remote server. However, the Job Agent throws an error whilst configuring the Package Parameters of that ...
wp78de's user avatar
  • 19.2k
1 vote
1 answer
742 views

I have a job in SQL Server 2014 that runs an executable which may or may not generate files. Afterwards the next step moves all the files generated to an SFTP site. Everything works if files exist. ...
Holmes IV's user avatar
  • 1,799
0 votes
1 answer
429 views

I am having a problem with execution of a shell command involving a VB script via a SQL Server Agent and also Windows Scheduler (I am trying to get at least one of these options to work). The ...
bda's user avatar
  • 422
0 votes
0 answers
260 views

I have a powershell script that I developed and can run fine manually. However when I put the script into a sql server job and attempt to run the following line... SET-LOCATION "$NewTargetPath\" ...
Lumpy's user avatar
  • 115
0 votes
0 answers
288 views

I have enabled RSS on few SQL Server recently. I need detailed output of job with it's steps completion duration pre and post enabling RSS. If anyone have the script, please do share. Script for ...
Iam_NC's user avatar
  • 45
4 votes
0 answers
1k views

I am using SQL Server 2016 and SSIS. I have a package in which I am calling a sql server job. My job have just one step as PowerShell command for transfering all files from one directory to another ...
Ardalan Shahgholi's user avatar
  • 12.7k
0 votes
0 answers
89 views

I Have a Sql Server 2014 Stored Procedure (SearchArticleByNumber) that I'm using for searching data and which works fine until Job schedule starts which job executes additional (five) stored ...
user3782230's user avatar
  • 155
9 votes
3 answers
22k views

I have a process and the first step is to check status of other process. If the other process is done I would want to run the rest steps and if not I would want to quit the job. I have a table that ...
Jack's user avatar
  • 323
0 votes
1 answer
3k views

I have created SSIS package with Send mail task It works (sends one email with multiple attachments) when I run SSIS package on SQL Server Data tools for Visual Studio But when I run same package ...
user2331670's user avatar
  • 335
1 vote
2 answers
281 views

I'm currently working on a SQL Server JOB file that contains the following code @active_end_date = 99991231, @active_start_time = 0, @active_end_time = 235959, @schedule_uid = N'59cbfb7d-67c7-...
Jarno343's user avatar
  • 91
0 votes
1 answer
41 views

Can we run job through SSIS packages in Server1 which scheduled in server2(that job is currently disabled in server 2) Kindly give me suggestions.
Hell Boy's user avatar
  • 981
0 votes
1 answer
188 views

I'm getting this error when running a SQL Server job: Description: Executing the query "EXEC Stgs.sp_SendEmail ?" failed with the following error: "SQL Server blocked access to procedure 'dbo....
AskMe's user avatar
  • 2,645
1 vote
1 answer
402 views

As I am a beginner in SQL Server and my scripting is not very polished yet. I need suggestions on the below issue. I receive files from a remote server to my machine (around 700/day) as follows : ...
Ayaz's user avatar
  • 171
1 vote
1 answer
175 views

PerformanceReview prID reviewDate passed notes successStrategy empID nextReviewDate above is my table I am working with, my goal is to get the nextReviewDate check to see if it is within 7 days of ...
ImDeveloping's user avatar
  • 101
1 vote
1 answer
6k views

Currently I am creating a SQL Server job. My requirement is whenever the job fails, it needs to run one more time. Is it possible in SQL Server?
bmsqldev's user avatar
  • 2,765
0 votes
1 answer
408 views

On SQL Server 2008 R2 Standard Edition, I created a credential TestCredential with identity as NT AUTHORITY\NETWORK SERVICE as explained here. Then I followed this article to create a proxy account ...
nam's user avatar
  • 24.3k
0 votes
0 answers
648 views

In our SQL Server 2008 Agent properties dialog box we have set an Alert System settings as shown below. But when we try to generate a script for that we get the following message - hence unable to ...
nam's user avatar
  • 24.3k
0 votes
1 answer
644 views

I am using SQL Server 2008 to create a job to calculate some values from an external db and store to another db table. A task scheduler has been created for automating this to run daily and update ...
Monu Thomas's user avatar
  • 35
0 votes
1 answer
1k views

Could someone explain and resolve the following issue. Thanks. I encountered this query issue when I run it in SQL Server 2012 on Windows Server 2012. The query (@query) runs very well when it ...
HoangDo's user avatar
  • 1
1 vote
1 answer
360 views

I am fairly new to creating server scripts and jobs that the server runs every day. My problem is as follow: I want to send an email to my users reminding them of a specific job they have to do. My ...
Marc Rasmussen's user avatar
  • 20.7k
0 votes
1 answer
630 views

we have a job that runs several times a day making incremental backups. We have added a step 'Send email on Job failure' that uses T-SQL to send an email to the admins team if the first step (...
Our Man in Bananas's user avatar
  • 6,025
0 votes
1 answer
56 views

We want to set a profile in Database Mail on SQL Server 2008 R2 for all the developers in our team to receive notifications once an overnight job has completed. Unfortunately, in the Notifications ...
Our Man in Bananas's user avatar
  • 6,025
3 votes
3 answers
4k views

I am trying to create an audit trail for actions that are performed within a web application, SQL server agent jobs and manually run queries to the database. I am trying to use triggers to catch ...
anothershrubery's user avatar
  • 21.1k
2 votes
1 answer
7k views

I am working with sql server 2012 and have some jobs set up on it to run at different times during the day. If the job fails I want to be alerted of such. On the server I have some software the ...
amateur's user avatar
  • 44.8k
19 votes
3 answers
84k views

How can I create a stored procedure to start a SQL Server job?
g_shockTan's user avatar
  • 355
0 votes
1 answer
1k views

I have a job in SQL Server 2000 which runs every night and refreshes the data, I have another job which runs after the data refreshes and update some records. Both of these jobs are not connected to ...
user2162617's user avatar
  • 1
0 votes
1 answer
2k views

I created a SQL Server 2008 Job when runs everyday at a specific time. When the job finishes, I can manually Export the job log as shown in the link below: http://www.websense.com/support/article/...
Pawan Pillai's user avatar
  • 2,085
4 votes
1 answer
8k views

The following SQL Server job always exits with return code 0 indicating success, when in fact it does not do its job, i.e. it does not delete "test.txt". How can I catch the actual exit code (...
prokilomer's user avatar
  • 43
3 votes
2 answers
2k views

I wish to use sp_start_job to start a job from within an insert trigger. The table which the insert trigger is on only has a few inserts a day atm. The point of doing this is so that the insert ...
Chris Cannon's user avatar
  • 1,167
0 votes
1 answer
3k views

I have a SQL Server Job running on server X. Now I have to delete the existing AS(Analysis Services) backup files on server Y and create a fresh backup again. I wrote the required code in a batch file ...
Vamshi Vangapally's user avatar
  • 2,032
2 votes
1 answer
7k views

A job, in which a proc is reading excel file using openrowset function and then exporting a file using bcp command. It was working perfectly until recently. When I run job it gives me this error:- ...
User13839404's user avatar
  • 1,833
2 votes
3 answers
3k views

Background: I created an application that measures a weight from a scale and saves the information in MS SQL server database. In the database, I want to save a record for the actual weight for every ...
Akrem's user avatar
  • 4,672

1
2