Skip to main content
Solved

MSSQL Statement erreur

  • September 19, 2022
  • 2 replies
  • 137 views
S
Forum|alt.badge.img+1

Bonjour,

 

J’essai d’exécuter une requête mssql qui me permet de récupérer une valeur 0 ou 1;

--sql-statement='SELECT top 1 run_status from [msdb].[dbo].sysjobhistory where job_id = 43496608-710F-4524-B7B4-C04EB673F385 order by run_date desc'

lorsque j’exécute celle-ci via une console SQL Studio Management cette requete fonctionne mais lorsque j’exécute celle-ci via le plugin j’ai une erreur.

UNKNOWN: Cannot execute query: Server message number=102 severity=15 state=1 line=1 server=SERVEUR\XXXX text=Incorrect syntax near 'F'.

Je n’arrive pas à voir l’erreur, avez vous une idée

 

 

 

Best answer by sims24

Bonjour,


Can you try like this please:

 

--sql-statement=”SELECT top 1 run_status from [msdb].[dbo].sysjobhistory where job_id = ‘43496608-710F-4524-B7B4-C04EB673F385’ order by run_date desc”

 

or

 

--sql-statement=’SELECT top 1 run_status from [msdb].[dbo].sysjobhistory where job_id = “43496608-710F-4524-B7B4-C04EB673F385” order by run_date desc’

View original

sims24
Forum|alt.badge.img+19
  • sims24
  • Ranger ***
  • September 20, 2022

Bonjour,


Can you try like this please:

 

--sql-statement=”SELECT top 1 run_status from [msdb].[dbo].sysjobhistory where job_id = ‘43496608-710F-4524-B7B4-C04EB673F385’ order by run_date desc”

 

or

 

--sql-statement=’SELECT top 1 run_status from [msdb].[dbo].sysjobhistory where job_id = “43496608-710F-4524-B7B4-C04EB673F385” order by run_date desc’

"It's shocking to find how many people do not believe they can learn, and how many more believe learning to be difficult." - Frank Herbert, 'Dune'.
S
Forum|alt.badge.img+1
  • SebastienL
  • Steward *
  • September 21, 2022

Bonjour,

 

Cela fonctionne, merci pour votre aide.

 

Cordialement

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings